Text File Reporting

[RP]

I am using C# with SQL Server 2005.

I have a table that looks like this:

EmpID Code
----------- --------
101 A1
101 B1
101 C1

102 A1
102 C1

103 B1
103 D1

I want to write like this in a text file:

EmpID A1 B1 C1 D1

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

Sql 2005 provides a way to convert rows into columns , take a look at Pivot
Formatting it is easy, you can do it from SQL itself, just use char columns