The AI suggests that the lower cost of flights in November might deter discretionary travel. I'd have thought that lowering costs would encourage it.

You can use IDENTITY_INSERT to allow inserts into identity columns

SET IDENTITY_INSERT [ [ database_name . ] schema_name . ] table { ON | OFF }

See

It might not be a good idea to ask computer-minded people to rate presentations as above or below average. If I've been to four talks in a day, it's likely...

The "redacted" zip file requires further work. For example, words beginning with "fellat" or "whor", not to mention the N-bomb.

You can also highlight all or some of the cells in an SSMS Results grid, right-click and choose "Save Results As..."

There's a cut scene which shows Jeff Goldblum working on the computer system of the crashed alien craft in Area 51 and presumably working out in advance how to hack...

Not that you'd necessarily want to, but you can't reference a synonym on a linked server by its four part name.

It contains its own dictionary

You could use a variant of this code which uses SELECT...FOR XML

http://sqlandme.com/2011/04/27/tsql-concatenate-rows-using-for-xml-path/

There are many other examples of this online

We do.

You could move it in SQL 2005

From Books Online (bold emphasis mine). Is this your problem?

Assuming that JMT_DATE is stored as a date rather than a string, this should do the trick

SELECT YEAR(MAS.JMT_DATE) AS "Judgment Year",

MAS.CRED_NAME AS "Creditor Name",

SUM(MAS.JMT_AMT) AS "Judgment Total"

FROM DBO_MASTER AS MAS

WHERE...

Or you might get

Msg 208, Level 16, State 0, Line 7

Invalid object name '#values'.

if you have the misfortune to be working on a case-sensitive database.