Comments by Member 11074115 (Top 1 by date)

I have written below query

select Value,Language from(
select Value,Language from [dbo].[getLabelValue1]
) up PIVOT
(SUM(Value) FOR Language IN(select Language from [dbo].[getLabelValue1)) as pvt

but it is throwing error after IN. It s not allowing query. Could you please correct my query