>In SQL Server you want to test proposed solutions as you don't know in advance (unless it's obvious) which solution will perform better.
>
>The simplest (although not necessary accurate) way to test is to put both statements in 1 batch and run with execution plan on and then see percentage difference.

Thanks