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 |
|
texasoeb
Starting Member
1 Post |
 Posted - 2007-05-02 : 12:00:28
|
| I have a need to read a table and extract records that matches a criteria (dough!, not that simple). Then I put the record in a text message and send them out via email. Works OK, but the problem is when I have multiple records for one entry. Since SQL doesn't have arrays "per say", I need to load the records on a "temporary array" then assembly the message at the end to include the records. Any suggestions how to "emulate" an array on a stored procedure (SQL), not sure what direction to follow. thanks |
|
|
cvraghu
Posting Yak Master
187 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-05-03 : 06:37:15
|
| Alternatively, if you use front end application, you can easily concatenate rows thereMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Handling multiple data records with sp