问题描述
我写了下面提到的查询...
I have written the query mentioned below...
DECLARE @cols AS NVARCHAR(MAX), @query AS NVARCHAR(MAX) select @cols = STUFF((SELECT distinct ',' + QUOTENAME(Name) from dbo.[WorkflowInstanceParameter] FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'),1,1,'') Go set @query = 'SELECT ' + @cols + ' from ( select wi.Id,wip.Name, wip.stringValue from FROM [ESP2_DEV1].[dbo].[WorkflowInstanceParameter] wip, [WorkflowParameterGroupInstance] wpgi, [ESP2_DEV1].[dbo].[WorkflowInstance] wi, dbo.WorkflowDefinition wd where wip.[WorkflowParameterGroupInstanceId] = wpgi.id and wpgi.[WorkflowInstanceId] =wi.id and wi.workflowDefinitionId=wd.id ) x pivot ( max(stringValue) for Name in (' + @cols + ') ) p ' execute(@query)
但它因错误关键字'FOR'附近的语法不正确"而失败
but it is failing with error "Incorrect syntax near the keyword 'FOR'"
谁能帮我这个吗??????
Can anyone help me this?????
推荐答案
关键字 FROM 在 set @query 子句中重复:
The keyword FROM is repeated in the set @query clause:
select wi.Id,wip.Name, wip.stringValue from FROM [ESP2_DEV1].[dbo].[WorkflowInstanceParameter] wip