Sending Advanced Mail in Sql Server 2005 Database Mail

• ercan_fb

  Old Hand

  Points: 334

  More actions

  October 14, 2008 at 8:37 am

  #213997

  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?)

• Garadin

  One Orange Chip

  Points: 29613

  More actions

  October 14, 2008 at 9:58 am

  #884727

  You'll need to use something like SSRS or Crystal Reports for that.

  Seth Phelabaum

  ---

  Consistency is only a virtue if you're not a screwup. 😉

  Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]