How to get Column names as rows with values

Create Table #Temp
		(
		coverage Real,
		services Real,
		medical Real
		)

Insert into #Temp 
Values(500,1000,1500)

Select Char(64+Row_Number() Over(Order by value)) [type],[desc],[value] 
From 
   (Select coverage,services,medical From #Temp)p
UNPIVOT 
   (value for [desc] in (coverage,services,medical)) unpvt

-- Output:
--type	desc	   value
-----	-------    ------
--A	coverage   500
--B	services   1000
--C	medical	   1500

Drop Table #Temp 

this is an example to show how to convert columns of one data table to another data table

here columns of data table dtm is converted rows of dt

for (int i = 0; i < dtm.Columns.Count; i++)
                    {
                        DataRow newRow = dt.NewRow();
                        newRow[0] = dtm.Columns[i].Caption;
                        for (int j = 0; j < dtm.Rows.Count; j++)
                        {
                            if (dtm.Rows[j][i].ToString() != "")
                                newRow[j + 1] = dtm.Rows[j][i].ToString();
                        }
                        dt.Rows.Add(newRow);
                    }

i suggest u instead of searching sql query for converting take all your data in data table then convert it