SQL Server Performance Forum – Threads Archive
plz help for customize script
Hi, Please provide the solution Username-rolename-project iD Rahul-dataentry-2 Vikas-verifier-2 Binu-verifier-3 Debashish-dataentry-3 Now I need the result like Dataentry-verifier-PROJECT IDRahul-VIKAS-2
Debashish-Binu-3 Amit Kumar
Mob.: 9873812005
http://www.sqlteam.com/item.asp?ItemID=2955 &http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true are good ones for such crosstab queries. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>