SELECT 1 id ,N'广州水尊建筑材料有限公司(梅林)' name
INTO #a
SELECT * INTO #b FROM (
SELECT 1 id ,N'张三' node,N'统一同意' content UNION ALL
SELECT 1 id ,N'李四' ,N'不同意' UNION ALL
SELECT 1 id ,N'王五' name,N'同意呀呀' UNION ALL
SELECT 1 id ,N'赵六' ,N'不同意啊啊' )a
SELECT a.*,b.node,b.content INTO #c FROM #a a JOIN #b b ON a.id=b.id AND b.node IN(N'赵六',N'王五') AND a.id=1
DECLARE @str1 NVARCHAR(1000),@SQL1 NVARCHAR(4000)
SET @str1=(SELECT STUFF((SELECT ',['+node+']' FROM (SELECT distinct[node] FROM #c)A FOR XML PATH('')),1,1,''))
SET @SQL1='SELECT id,name,'+@str1+' FROM #c PIVOT(MAX(content) FOR node in('+@str1+'))A'
EXEC (@SQL1)
DROP TABLE #a,#b,#c
INTO #a
SELECT * INTO #b FROM (
SELECT 1 id ,N'张三' node,N'统一同意' content UNION ALL
SELECT 1 id ,N'李四' ,N'不同意' UNION ALL
SELECT 1 id ,N'王五' name,N'同意呀呀' UNION ALL
SELECT 1 id ,N'赵六' ,N'不同意啊啊' )a
SELECT a.*,b.node,b.content INTO #c FROM #a a JOIN #b b ON a.id=b.id AND b.node IN(N'赵六',N'王五') AND a.id=1
DECLARE @str1 NVARCHAR(1000),@SQL1 NVARCHAR(4000)
SET @str1=(SELECT STUFF((SELECT ',['+node+']' FROM (SELECT distinct[node] FROM #c)A FOR XML PATH('')),1,1,''))
SET @SQL1='SELECT id,name,'+@str1+' FROM #c PIVOT(MAX(content) FOR node in('+@str1+'))A'
EXEC (@SQL1)
DROP TABLE #a,#b,#c