Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Complex Dynamic Cross tabs

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-01-18 : 08:56:18
Mano writes "I have a table like the following:

ID Name Param Value
1 ApprSpeed CAS 163
1 ApprSpeed VSS 1007
1 ApprSpeed HAA 941
2 ApprSpeed CAS 203
2 ApprSpeed VSS 1107
2 ApprSpeed HAA 841
4 HighROD VSS 1372
4 HighROD HAA 478
5 HighROD VSS 1577
5 HighROD HAA 780


ID Name CAS VSS HAA
1 ApprSpeed 163 1007 941
2 ApprSpeed 203 1107 841
4 HighROD 1372 478
5 HighROD 1577 780


I've tried with the examples provided on your site but I was unsuccessfull. Please help. Thanks."

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-01-18 : 09:57:03
See if these help
http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true
http://weblogs.sqlteam.com/jeffs/archive/2005/05.aspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -