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 |
|
elephantman
Starting Member
6 Posts |
 Posted - 2008-10-14 : 10:35:42
|
| Hi i have a stored procedure and it returns two fields as email and requestIDsi take emails as recipients and send requestIDs to our usersNow i want to improve my stored procedure to send requests as a table or report with more than one field. But i dont know how to improve it? Could anyone help on thishere is my stored procedure's query section:set @rec = (select email + ';' from (select distinct email from ST$Users K left join ST$Requests I on K.id=I.Istek_Sorumlusu left join ST$RequestLines IST on I.istekid=IST.IstekNo where istek_durumu<20 and datediff(day,Tarih,getdate())>1)t for xml path(''))after i do the query how could it be possible to send mail as a table or report. (Like a gridview for example maybe giving colors? is that possible?) |
|
|
elephantman
Starting Member
6 Posts |
Posted - 2008-10-15 : 03:14:07
|
| using Reporting Services can solve my solution? can it be send mails in tables or pdf format or etc? |
 |
|
|
|
|
|
Send Advanced Mail in Database Mail