Thanks guys but just to straighten things out I am not really a DBA, I know the basic stuffs but digesting the difference of that posted code is out of...

The first option I am getting this

SQL Server parse and compile time:

CPU time = 0 ms, elapsed time = 0 ms.

SQL Server Execution Times:

...

It is not actually for me and I just want to test if the 2nd option is really better than the first one. Upon running them in the Profiler they...