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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-07-11 : 11:19:13
|
| Ailsa writes "How do you create a "flat file" (I'm not sure of the correct term)eg: Existing data IDNo ReceiptNo Date Description Amount 1234 10053689 01/07/2005 General $10.00 1234 10069468 01/08/2005 Cataract $20.00 1234 10078942 01/09/2005 General $10.00Want it to be formatted this in 1 row:FieldNames:IDNo Receipt1 Date1 Description1 Amount1 Receipt2 Date2 Description2 Amount2 Receipt3 Date3 Desription3 Amount3Data:1234 10053689 01/07/2005 General $10.00 10069468 01/08/2005 Cataract $20.00 10078942 01/09/2005 General $10.00" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Creating a "flat file" 