how to send a email before one day of myselecteddate.

• mr1362002

  Newbie

  Points: 7

  More actions

  September 3, 2013 at 10:58 pm

  #281962

  Hi All,

  I have a table with one column as date field myselecteddate. If the current date is one day before myselecteddate I need to send an email through sql server.

  I will use datediff and find the difference between myselected date and Currentdate. Then if some rows returns 1 . Then how to fetch them if difference =1 and send an email.

  Any suggestions or ideas will be helpful.

  Thanks.

• Dennis Post

  SSCarpal Tunnel

  Points: 4473

  More actions

  September 4, 2013 at 7:05 am

  #1647282

  Make an attempt with your own logic and i'll help fill in the gaps.

  E.g.

  if comparison

  begin

  send email

  end

  or maybe this is enough

  ---

  
  For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

  "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734449

  More actions

  September 4, 2013 at 7:52 am

  #1647315

  hint: you can use exists()