You're welcome, Jason, and Happy New Year. 😀

While you are doing your homework on FOR XML, be sure to look up nested queries in conjunction with PATH. ...

I also want to ask two questions just to make sure everyone is understanding correctly.

When you say "restore my database with this file", are you saying you believe this file...

Who was it that defined legacy code as the stuff that has been around so long that you finally got most of the bugs out of it?

Hey Jason,

After Matt's comment in your other post, I realized that there was a much better way.... using SELECT/FOR XML. The query at the bottom produced...

Jeff: You have a great New Year's too! I'm off to Dallas to watch my Rebels play Texas Tech in the Cotton Bowl.

Matt: Quit spoiling everybody's...

Have you tried using a CTE? CONVERT the datetime column to a string in the cte, and then build your xml off the CTE instead of the...

Why do you need to? It's empty.

Fifteen yard penalty for illegal use of The Force... will be assessed from the line of scrimmage.... third down...

Peculiar... on our 2008 development box (which is pretty quiet this week), I ran Jeff's original test and all three ran almost neck and neck. EXISTS squeaked...

When I googled "sp_OAMethod Excel Refresh", I saw that you had this same question posted on at least one other SQL forum. The problem is that it's not...

Calm down, Jeff. Have some Eggnog. Maybe a pork chop. 😀

I think the OP has abandoned us anyway. Don't know whether it was...

You have a couple of options, but they aren't things you can specify in T-SQL.

BCP can run queries and put their output in a file.

http://www.sqlservercentral.com/scripts/Backup+%2F+Restore/30027/

So...

Here is a high level approach to doing it with dynamic SQL.

1. Get list of columns for the table in question.

select c.name,...

You're a good soul, Chris Harshman 🙂

Maybe I'm just getting cynical, but I'm finding myself less and less willing to help people who are just throwing up a problem and...

Matt, that was my first thought, but there's a problem if they just defined the identity property for the column without expressly creating a constraint.

Try this:

Create table dbo.dummy (ID int...