Hi to all,
I like to start a new discussion after a long gap..Now i have a Question in Sql,I need to Take a difference in Current Month and Previous month,from get the diference i use the trigger to send a sms..
SELECT datepart(mm, dateadd(mm,-1,'2011/1/1') )
or
SELECT DATEADD(MONTH,-1,GETDATE()).i need to filter a exact date from a one month gap.
Ex: If a person buy a product in last month,again he come into the same store and buy a same product (Condition Apply:within one month ).I like to Trace the exact date and send a sms from that date..Kindly refer some ideas..