sql 2000 table format - SQL Server Forums

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)

sql 2000 table format

Author

Topic

fmardani
Constraint Violating Yak Guru

433 Posts

Posted - 2006-06-05 : 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

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-06-05 : 05:46:49

Can't you do this in your front end application ? SQL Server is for data storage and not meant for Formatting and Presentation of data.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources