Timeline for Generate CSV Email For Each UserID In Table
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 23, 2017 at 11:33 | history | edited | CommunityBot |
replaced http://stackoverflow.com/ with https://stackoverflow.com/
|
|
| May 11, 2017 at 16:47 | comment | added | John Eisbrener |
You would have to execute a separate sp_send_dbmail call for each CSV you wished to send out, or alternatively write out all the csvs to the file system and then append all of them to one final email via the @file_attachments parameter.
|
|
| May 11, 2017 at 16:33 | comment | added | Smith Stanley | I have used sp_send_dbmail before I just was not sure how to split out the result set of the select statement so that each userID returned gets a seperate .csv file. | |
| May 11, 2017 at 16:28 | history | answered | John Eisbrener | CC BY-SA 3.0 |