Problem conversion row to column

Transact-SQL
22

Ok,problem not solved.thanks alot

24

Your answer for me not understand

26

please see:
http://www.c-sharpcorner.com/forums/my-procedure-not-have-output-in-c-sharp-for-datasoure-gridview

27

I have another question about this problem.
I have this procedure:
ALTER Procedure [dbo].[test3] as Declare @Cols varchar(max), @Sql varchar(max) Set @Cols=('''''AS [a]'); print @cols Set @sql=' select 1 as[one], ' + @Cols exec (@Sql)

This procedure have records in Gridview C# but different with the above code and code below is a 'select' and code below no any record in Gridview C#!!
ALTER Procedure [dbo].[test3] as Declare @Cols varchar(max), @Sql varchar(max) Set @Cols=(Select '''''AS [a]'); print @cols Set @sql=' select 1 as[one], ' + @Cols exec (@Sql)

28

How to be above Code with 'Pivot'?

29

i have posted the PIVOT query 3 days ago here