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)
 Extra Columns

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-04-18 : 08:49:43
Rodney writes "I have a table with one column called Stock_num. There are thousands of rows in this table.
I would like to print a 4-column report of stock numbers, sorted by stock number.

This is just one sample page of the desired output from the 1-column table:


1 6 11 16
2 7 12 17
3 8 13 18
4 9 14 19
5 10 15 20
"

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-04-18 : 08:56:07
You want to do it in T-SQL ? Can't you do this in your front end application ?



KH


Go to Top of Page
   

- Advertisement -