I have a Table1 with say 3 cols. which has datetime as 1 col.I want to get the difference of rows for 2 diff dates as the condition for the same table.And want to compare the difference value against
a fixed value say o.3.so this is sumthing like.....
(col1---col2--datetime1) - table1 (col1---col2--datetime2)= difference value;
if difference value>0.3 send an email alert
this has to happen on the daily basis....automated.....
can any 1 pls help me out how can i achieve this....
i was wondering to write a winform appl and schedule the task on daily basis or
can i do it from the sql serve itself instead of doing it with .net/winforms.
pls help me ....Thanks a million for ideas.....!!!!!!!!!!!
View Complete Post