Hi Jim,

Don't know if this works with SQL Server, but with mySQL I can do...

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

HTH,

Chris

----- Original Message -----
From: "jim wasley" <wasleyj@a...>
To: "sql language" <sql_language@p...>
Sent: Thursday, July 25, 2002 10:07 PM
Subject: [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
>