Viewing 6 posts - 16 through 21 (of 21 total)
Thanks for the example, it was helpful to an extent, though did solve the complete problem.. I need a way to check the next an previous row values depending...
June 22, 2010 at 11:02 am
I know it is monday but I really feal dense.
Sorry Dan..It works perfectly .. i screwed up something and i was testing it against my table and was getting wrong...
June 21, 2010 at 3:18 pm
you indicate you are having a problem with the Query I provided but I am not sure what problem you are having.
Dan, When i execute the SQL.. it is selecting...
June 21, 2010 at 2:05 pm
Hi wayne,
Thanks for pointing about the indexes.. i do have indexing on the table. i tested your SQL and i see that it results the same inserted data without...
June 21, 2010 at 1:48 pm
Thanks for correcting the statement.. I have tried the sql and it updates the value with the last DateTime value i.e., '2010-04-13 04:00:00.000' instead of updating it with the next...
June 21, 2010 at 1:31 pm
Guys please help me out.. atleast suggest me an idea..Thanks
June 21, 2010 at 8:04 am
Viewing 6 posts - 16 through 21 (of 21 total)