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.
| Author |
Topic |
|
mncprogrammer
Starting Member
1 Post |
 Posted - 2004-09-16 : 04:13:01
|
| Old COBOL programmer learning SQL / Excel reporting. I have a table with one 6 byte char field containing all unique numbers (right justified, zero filled) this data was created from a IBM Mainframe. I want to pass this to excel starting in cell a1 thru a14 and continue to b1...b14 to the end. With 99000 numbers @ 14 columns for ea row, I would need about 7072 rows. I tried it with a pivot table and maxed out on 1 row. |
|
|
|
|
|
SQL \ Excel - 1 field to 14 columns per row