sql字符字段分组链接代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】 sql字符字段分组链接

作者: / 发布于2011/1/1/ 545

<div>USE [SSF_DATA_WFDS]
GO
/****** 对象: View [dbo].[vtrmPickUpTaskGroup] 脚本日期: 08/04/2010 10:06:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [dbo].[vtrmPickUpTaskGroup]
AS
SELECT TO_WAREHOUSE, TOR_PLANT, TOR_LOCATION, TOR_MATERIAL, TOR_MATERIALDESC,
TOR_UNIT, TOR_SPSTOCK, TOR_SPNO, TOR_STOCKTYPE, 
 TOR_SBIN, TOR_SSTORAGETYPE, TORU_CURUSER,
SUM(TOR_SQTY) AS TOR_SQTY, TOR_BATCHNO, MAX(TORU_PRI) AS TORU_PRI, MIN(CREATEDATE) 
 AS CREATEDATE
,
stuff
(
(
 select ','+convert(nvarchar(20),TOR_ID) 
 from (select * from vtrmPickUpTask) b 
 where b.to_warehouse=a.to_warehouse AND b.TOR_PLANT=a.TOR_PLANT 
AND b.TOR_LOCATION=a.TOR_LOCATION
AND b.TOR_MATERIAL=a.TOR_MATERIAL
AND b.TOR_MATERIALDESC=a.TOR_MATERIALDESC
AND b.TOR_UNIT=a.TOR_UNIT
AND b.TOR_SPSTOCK=a.TOR_SPSTOCK
AND b.TOR_SPNO=a.TOR_SPNO
AND b.TOR_STOCKTYPE=a.TOR_STOCKTYPE
AND b.TOR_SBIN=a.TOR_SBIN
AND b.TOR_SSTORAGETYPE=a.TOR_SSTORAGETYPE
AND b.TOR_BATCHNO=a.TOR_BATCHNO
AND b.TORU_CURUSER=a.TORU_CURUSER
for xml path('')
),
1,
1,
''
) TOR_ID_GROUP
FROM (select * from dbo.vtrmPickUpTask) a
GROUP BY TO_WAREHOUSE, TOR_PLANT, TOR_LOCATION, TOR_MATERIAL, TOR_MATERIALDESC, TOR_UNIT, TOR_SPSTOCK, TOR_SPNO, TOR_STOCKTYPE, 
 TOR_SBIN, TOR_SSTORAGETYPE, TOR_BATCHNO,TORU_CURUSER
</div>

试试其它关键字

　字段分组　

同语言下

可能有用的

贡献的其它代码Label