Whether or not to use varchar or nvarchar really depends on the type of data you're storing. If you are not now or ever going to store different character sets...

Clarification: "Column aliases in ORDER BY clause cannot be prefixed by table alias"

Sorry. What I said earlier was misleading. Also, on rereading, I'm not shocked that this doesn't work. I'm...

Darth Vader is better than Leather-face, which was what I came close to.

"I find your lack of indexes disturbing..."

Yep. I'm just starting the process of evaluating all our 2000 servers using the 2008 Upgrade Advisor. That's one syntax error that's popping up all over the place. I'm a...

The old parser would also let you refer to columns by the table alias and the new one does not.

Have you taken a look at the execution plans? Are different tasks being performed by the system?

Second vote for making sure you did maintenance after the upgrade, especially updating statistics...

Use SQL Agent to schedule the time for the daily run. You can run a tsql statement from within the Agent job.

Well now, our methods worked, but they were predicated off of joins and a single row out of each set, not multiple rows out of each set. I still think...

Chris Morris (12/1/2008)

Thanks for the tip, Grant, Ill try and get hold of that article. Do you mean this...

SELECT o.*

FROM #TOPTEN AS o

WHERE BATCH = 10

AND [ID] IN

(SELECT...

No, no, no apoloogies. If there's any misunderstanding, it's on my side. I think your solution is likely the only one. I've never needed to capture an output from sqlcmd...

Output to what? I mean what am I outputing to? Sqlcmd can just output to a file pretty easily if that's what you need.

You would want to use it with any of the ORM tools that try to walk the structure of the data returned. By masking the table structure off behind the...

I'd suggest using the TOP and an ORDER BY within the sub-query instead. Assuming there is an index for the ORDER BY clause to use, I think you'll see better...

As everyone else has said, it depends.

I used to use the approach of an identity column on most, if not all, tables. I've learned better. Now I tend towards what...

The way I've done it previously is to output the procedure to XML and store it on the side. Then as you make adjustements to the query, you can compare...