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

Permits? We don't need no stinking permits.

Seriously though, the main reason I keep coming back here, well, in addition to learning something every single day, is that the tone is...

Well, it was a thrilling moment, I don't mind saying. I'll be picking up one of those integrated face sheild/helmet/ear protection things soon (read ASAP). First time in 10 years...

I'm sort of loving the long weekend. I'm busting butt on the stupid book and I'm chain-sawing & splitting wood to get ready for the winter.

Broke a chain for...

rbarryyoung (11/29/2008)

---

Probably himself. Seriously. It's easy...

rbarryyoung (11/28/2008)

---

it's not too bad, Grant. The presumption is that all tenants are using the same software and schema, just that every data row is tagged with a Tenant...

May as well chime in on this one.

First off, Phil, feel lucky. At least your developers are still at least using the words "data." We've had a rash of the...

Yikes! I'd say so. Upgrades to the data model must be entertaining.

GilaMonster (11/27/2008)

---

It could be worse. Like this one - developer background, now a senior DBA, depends on forum answers to do their job

Train wreck waiting to happen.

If you want some...

J (11/27/2008)

---

First off, WHY do you "need" (??) to create tables and set table ownership ?

Could you not just use a common table with an extra field like "OwnerID"to keep...