Need Help

[gupta_prash]

Hi there,

I want to achive the following but stuck big time.

I got a table with the following values for eg

ID Name Created
1 ABC 01/02/06
1 DEF 03/02/06
1 ABC 04/02/06
2 SDF 02/02/06
3 DEF 03/02/06
3 ABC 04/02/06

I want to achive it as

ID Name1 Name2 Name3
1 ABC DEF ABC
2 SDF
3 DEF ABC

Is there any way around this. I'm using views from SLQ server database.

Thanks

[sraheem]

U can write a procedure to export data in that format to a text file, then use that text file to make ur report. There may be an easy way as well
Raheem AHmed