Hugo Kornelis (8/16/2012)

---

Actually, this is not a...

A good question. This is a drawback to using table variables for temporary storage that you need to remember to work around.

Nice question. This trips up a lot of people new to SQL and seems to lead to a lot of negative feelings towards NULL values.

(NULLs aren't bad, they're just...

Nice question!

Haha yea, with all of the...

I'm not sure from your question if you want the summary value from the month 12 record of the previous year, or if you are trying to sum up multiple...

You can find the backup size in msdb.dbo.backupset.

I didn't know they'd increased the maximum size for SQL Server Express 2008 R2, so thanks for the question!

Why is a regular query not sufficient?

Is is unknown whether any of the given parameters will contain a value?

Nice question, thanks!

I remember a long time ago (SQL Server 2005?) having performance issues using COALESCE...

I thought for sure this was some sort of trick question... very happy to get it right. 🙂

mhg1063 (8/7/2012)

---

Records table:

ID | LNAME | FNAME |State Cd

----------|----------|--------- |

0000001 | Bloggs | Joe ...

You can try using a case statement in your join for each potential column.

SELECT

A.ColumnA1,

B.ColumnB2

FROM

TableA A

Join

TableB B

ON 1 = 1

AND A.ColumnA1 = CASE @ColumnName WHEN 'ColumnB1' THEN...

Sean Lange (8/7/2012)

---

This is indeed the second question on this topic in a few days that is quite ridiculous. Why would I care how comments are handled inside dynamic sql?...