SELECT DISTINCT BizID,STUFF((SELECT ',' + ApproveNameFROM T_Common_ApproveNodeWHERE BizID = A.BizIDFOR XML PATH('')),1,1,'') AS ApproveNameStr FROM T_Common_ApproveNode AS ABizID | ApproveNameStr 000835d70a99447f96b21d4b827c45d8|何磊,胡莊,陳侃,沈聰祖,殷玥,張潔4,何磊,何磊 0010f69ef6f04d0ab0118ebd336c5454|程闊,王曉康1,玄麗薇,傅燎華,劉爽1,吳萬龍 001ca702982a4311bd4dd8278738a310|周薇,張國(guó)慶,張聚實(shí),谷世友,張潔4,常春林,高超偉,谷世友 0010f69ef6f04d0ab0118ebd336c5454|程闊,王曉康1,玄麗薇,傅燎華,劉爽1,吳萬龍--輸出JSON 字符串 SELECT TOP 10 InvoiceCategory,InvoiceType FROM T_BILL_INVOICE FOR JSON PATH('')--輸出XML SELECT TOP 10 InvoiceCategory,InvoiceType FROM T_BILL_INVOICE FOR XML PATH('')SELECT ''''+ CAST( AA.ProgramID AS VARCHAR(1000) ) +''','FROM (select * from (select a.ProgramID,(select top 1 c.ParentProgramID from Sys_ProgramList c where a.ParentProgramID=c.ProgramID) ParentProgramIDfrom Sys_ProgramList a inner join Sys_PageMain b on a.ProgramID=b.ProgramIDwhere ISNULL(a.IsShow,0)=1 and isnull(a.IsBillPage,0)=1 and b.ListProgramID<>b.ProgramID) BillMain where isnull(ParentProgramID,0)<>0 ) AS AA FOR XML PATH('')select STUFF((SELECT '{"businessCode":'+ cast(billno as varchar(20)) +'"'+ ',"operatorCode":'+(select cUserCode from Sys_User WHERE iUserID = Bywho)+'"'+',"auditStatus":PASS"'+'"'+',"approvalTxt":審批通過"'+'"'+ ',"auditDate":'+ CONVERT(varchar(100), endtime, 21) +'"'+'}'FROM DJLXSZ60_log WHERE node = 18 and nodestatus = 5 and endtime > '2019-4-24' order by endtime desc for xml path(''), type).value('.', 'varchar(max)'), 1, 1, '')

轉(zhuǎn)載于:https://www.cnblogs.com/imtudou/p/11251848.html

總結(jié)

以上是生活随笔為你收集整理的Sql 行转列 STUFF的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。