在SQL数据里已经写好动态行转列语句如下,但是要如何在活字格里像视图一样把此sql语句存为一张外部数据表,就是保存一张表打开就能看到这些动态数据
DECLARE @cols AS NVARCHAR(MAX),
@query AS NVARCHAR(MAX);
SET @cols = STUFF((SELECT distinct ',' + QUOTENAME(c.dept_code)
FROM wip c
FOR XML PATH(''), TYPE
).value('.', 'NVARCHAR(MAX)')
,1,1,'')
set @query = 'SELECT intime, ' + @cols + ' from
(
select intime
, dept_code
, backlog_sq
from wip
) x
pivot
(
max(backlog_sq)
for dept_code in (' + @cols + ')
) p '
execute(@query)
|