You can get your required information using following pretty simple steps:

1.                  Open enterprise manger

2.                 ...

The @variable table is much better than #temp table and derived table much better than @variable table. And bulk inserts much better then iterative insert.

Thanks,

Irfan...

The join philosophy and optimizer work for choosing the best execution plan:

How many ways are there of joining two tables:...

Hi,

I have done little overview of your query code and following are some suggestions for query improvment and gaining the performance:

1.   Please should reduce the number of joins because (maximum 3 or...