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 |
|
uberbloke
Yak Posting Veteran
67 Posts |
 Posted - 2001-08-30 : 08:32:10
|
| Background.Ordering system that has items, with stock levels and notificiation levels.SituationWhen an order is accepted I need to check each item in the order to see if it has gone below the notification level.ProblemI can do this, but I want to stuff details about each item (name, current quantity, notification level) into the body of an email message and fire it off.The best I have come up with is to populate a temp table with the results of a select and then to loop through the temp table (I was going to troll and say "using a cursor" :-) putting the data into a @bodyText variable.Is there any way of getting the data directly into the @bodyText variable, or a better way of doing this? |
|
|
|
|
|
Getting Select Details into an Email