我有一个SQL表,如下所示:DECLARE @BI_ResponsibleID INT , @CategoryID INT , @ChangeRequestorID INT
SET @CategoryID = 3 [BI_ResponsibleID], [ChangeRequestorID]
FROM [BI</e
SELECT ISNULL((SELECT Sum(qtt) FROM bi(nolock) WHERE bi.ndos = 34 AND bofref like#1# AND bi.ref = temp.ref GROUP BY ref), 0) AS 'LPP',
ISNULL((SELECT Sum(qtt) FROM bi(nolock) WHEREbi.ndos = 28 AND bofref like #1# AND <