日期:2014-05-17 浏览次数:20431 次
DECLARE @T TABLE(OrderNO INT,LineID INT)
INSERT INTO @t
SELECT 5,1 UNION ALL
SELECT 5,2 UNION ALL
SELECT 6,1 UNION ALL
SELECT 6,2 UNION ALL
SELECT 6,3 UNION ALL
SELECT 7,1 UNION ALL
SELECT 8,1 UNION ALL
SELECT 8,2
SELECT * FROM @T