Chris, whats on your mmind..Which Method is better..first or second..??

Hi..I'm not convinced why you are using a UNION ALL in this context..??

Thanks for the solution....

My opinion is that first concentrate on the development side rather than DBA.

That will help you to learn a lot..then you can go the admin part...

Try a MS certification on...

Hi

Very Useful article series...Thank You

Eagerly waiting for your 'Charting the Unknown' article & 'Designing a Dashboard'.

Please publish it soon....Thanks a lot once again..

Hi

This link will solve your prob

http://bytes.com/topic/sql-server/answers/531936-how-convert-rows-into-columns

Hi..

Go through this link

http://www.sqlservercentral.com/articles/Change+Data+Capture+(CDC)/64289/

Hi

I hope the below links will serve your requirement.

http://www.sqlservercentral.com/articles/T-SQL/2937/

http://www.sqlservercentral.com/articles/T-SQL/63322/

Hi

Just refer this link

http://www.mssqltips.com/tip.asp?tip=1145

Similarities are listed in this link

http://www.mssqltips.com/tip.asp?tip=1556

Hi ..Another link

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2008/03/30/sql-server-table-variable-vs-local-temporary-table.aspx

Hi

Just refer this post

http://www.sqlservercentral.com/Forums/Topic1055670-391-1.aspx

Just searching the older posts will fetch you answer for these questions.!!

Hi

Refer this post..It will help

http://www.sqlservercentral.com/Forums/Topic791603-5-1.aspx

Hi

Refer this link also

http://beyondrelational.com/blogs/ashish/archive/2009/07/31/temporary-tables-and-table-variables.aspx

Also refer

http://msdn.microsoft.com/en-us/library/ms174965.aspx