ALTER PROCEDURE dbo.sp輸入對數(shù)核對_針車匯總
(
@工廠單號 nvarchar(20),
@工廠款號 nvarchar(10),
@顏色 nvarchar(20),
@工序 nvarchar(4)
)
AS
SELECT 工廠單號, 工廠款號, 顏色, 工序, SUM(生產(chǎn)對數(shù)) AS 生產(chǎn)對數(shù)Sum
FROM dbo.針車計件日報明細(xì)
GROUP BY 工廠單號, 工廠款號, 顏色, 工序
HAVING (工廠單號 = @工廠單號) AND (工廠款號 = @工廠款號) AND (顏色 = @顏色) AND (工序 = @工序)
ALTER PROCEDURE dbo.sp輸入對數(shù)核對_針車匯總
(
@工廠單號 nvarchar(20),
@工廠款號 nvarchar(10),
@顏色 nvarchar(20),
@工序 nvarchar(4),
@sum int output
)
AS
SELECT 工廠單號, 工廠款號, 顏色, 工序, @sum=SUM(生產(chǎn)對數(shù)) AS 生產(chǎn)對數(shù)Sum
FROM dbo.針車計件日報明細(xì)
GROUP BY 工廠單號, 工廠款號, 顏色, 工序
HAVING (工廠單號 = @工廠單號) AND (工廠款號 = @工廠款號) AND (顏色 = @顏色) AND (工序 = @工序)