Just wondering, did you think of normalization when you where
designing you database?
This table look like holding alot of redundant information/data.
Mayby you have DENORMALIZED for efficiency?

Well, it's just a thought!

Regards
/ Ali



-----Ursprungligt meddelande-----
Från: jim wasley [mailto:wasleyj@a...]
Skickat: den 26 juli 2002 00:08
Till: sql language
Ämne: [sql_language] Multiple row inserts to one column?


How could I populate a single column with multiple rows of information
within one INSERT statement/stored procedure in a single transaction?

INSERT INTO PUBS (UserID, FName, LName, Date, Download)
Values (id, fname, lname, date, download1, download2, download3)



UserID______FName________LName_____Date__________Download
000054      Joe          Dough     7/25/02       Wrox SQL Demo
000054      Joe          Dough     7/25/02       Wrox VB.Net Examples
000054      Joe          Dough     7/25/02       Wrox Linux Programming