Samuele E. Locatelli
9 lines
239 B
Transact-SQL
9 lines
239 B
Transact-SQL
CREATE PROCEDURE [dbo].stp_RMD_getByKey
|
|
(
|
|
@RawMat nvarchar(50)
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT RawMat, ProcCost, ProcYield, CSR, SSR, SSVA, SSVR, ExtraMatCost, ExtraServCost
|
|
FROM RawMatDet
|
|
WHERE (RawMat = @RawMat) |