Pivoting to a Single Column in SQL

Question

Hi All,

I have a Database table structure in the following format..

ID	Value
100	ADE
100	BCD
100	CEF
101	MNO
101	PQR
101	XYZ
102	EFG

I want a query to retrieve the results of table in the following format.

ID	Results
100	ADE,BCD,CEF
101	MNO,PQR,XYZ
102	EFG

I know that we can accomplish this by PIVOT Keyword but not able to finalize the query, can you guys help me out Please

Thanks in Advance

Vishwas

Answer 1

First of all be sure that you are importing/using (depending on language) the System.IO namespace for this to work. But what you can do is something like this

string pathToCreate = "~/UserFolders/" + TextBox1.Text;

if(Directory.Exists(Server.MapPath(pathToCreate))

{

   //In here, start looping and modify the path to create to add a number

   //until you get the value needed

}

 

//Now you know it is ok, create it

Directory.CreateDirectory(Server.MapPath(pathToCreate));