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...

Oops. Missed that this was SQLCMD

That's OK. You can use SQLCMD variables the same way, still using OUTPUT parameters. For more on SQL Command variables, this is BOL: ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_1devconc/html/793495ca-cfc9-498d-8276-c44a5d09a92c.htm

Or online...

Use output parameters. They work a little like this:

--create a procedure

CREATE PROCEDURE dbo.MyProc

@ID int OUTPUT

AS

SELECT ID FROM schema.Table

GO

--now you can call the proc like this

DECLARE @LocalId int

EXEC dbo.MyProc @ID =...

I think you've hit the nail on the head here Tony. I don't agree with either of the wild fringe groups. I think that well designed apps take advantage of...