Correct answer should be Currentdate + 2

If you try to execute the script by using Ctrl+c and Ctrl+v in query workbench

you will get the above said result

/*

select...

Thanks link to http://www.truthsolutions.com was really useful.

Deadlocks It would be helpful to me if you can send me snapshot of deadlock occurences (using Profiler)  my emailid is