Alert query

[Former Member]

HI all,

My customer need alerts/reminders for paying the monthly eb bills, telephone bills etc... so i created a table with code, description and date..like 01 telephone bils 06/04/11....... now the problem is if i give phone bills date as today and eb bills date as tomo... in todays alert i should get only telephone bills and in tomo bill i should get eb... while alert i should not get both at the same time it should pop up only based on the given date..

regards,

Vignesh

[kvbalakumar]

Hi Vignesh,

Try this

Select * from @YOURTABLE_NAME T0 where  datediff(dd,T0.U_date, getdate()) = 0

Note: Instead of T0.U_date put your exact field

Regards,

Bala