|
fmardani
Constraint Violating Yak Guru
431 Posts |
 Posted - 06/05/2006 : 04:36:58
|
There is a table with the following fields:
id,year,UserCode,A2,A3,B2,B3
Usercode is a varchar fields whereas the other fields are integrers.
Let's say this is what the table contains at present:
id year Usercode A2 A3 B2 B3
1 2005 2BM 12 7 9 11
2 2002 BB1 87 98 4 32
3 1999 3NS 45 32 88 12
...
The question is, how can I produce something like the following table using the above table:
The idea is to show the final table (at the very bottom) on a web page. So I am thinking if I get the table right in sql server then the rest is fine.
2BM BB1 3NS
A2 12 87 45
A3 7 98 32
B2 9 4 88
B3 11 32 12
Since I am using sql server 2000, I do not think I can use something like the pivot sql functionality as sql 2005 allows.
In addition to the above I would like to go one step further to have a sql to produce the following result (Notice the extra texts):
2BM BB1 3NS
user info
positive nums
A2 12 87 45
yesterdays info
negative values
A3 7 98 32
contact manage
B2 9 4 88
contact method
B3 11 32 12
Thanks
|
Edited by - fmardani on 06/05/2006 04:43:22
|
|
sql 2000 table format
