IF OBJECT_ID ('dbo.GETCKMX') IS NOT NULL
DROp FUNCTION dbo.GETCKMX
GO
CREATE FUNCTION GETCKMX(@ID INT)
RETURNS @P TABLE(WLID INT, ColorMCH VARCHAr (80),
SizeMCH VARCHAr (80), ColorID INT,
SizeID INT, SHL numeric(24,8),
BSHL numeric(24,8)
) AS
BEGIN
INSERT INTO @P(WLID,ColorMCH,SizeMCH, colorid,sizeid,SHL,BSHL)
SELECT WLID ,ColorMCH=B.NAME ,SizeMCH=C.NAME ,colorid,sizeid,SHL=sum(SHL),BSHL=sum(isnull(BSHL,0))
FROM STOCK A,ColorMXB B,SizeMXB C
WHERe A.WLID =@ID AND A.colorid =B.MXID AND A.sizeid =C.MXID
GROUP BY A.WLID ,A.colorid ,A.Sizeid
return
end
GO