|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Saturday, October 25, 2008 2:53 AM
Points: 6,
Visits: 38
|
|
Hi
i have a stored procedure and it returns two fields as email and requestIDs
i take emails as recipients and send requestIDs to our users
Now 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 this
here 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 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?)
|
|
|
|
|
Right there with Babe
Group: General Forum Members
Last Login: Thursday, June 11, 2009 11:23 AM
Points: 766,
Visits: 1,909
|
|
|
|
|
