Thinking about it some more... how do you write a procedure...

Well, I assume that you know what you want to get, what data set you're looking for, first. Armed with...

If I understand the question, I guess it's something I do every day (all day sometimes). First, I need to have a set of working parameters. Preferably, I have some...

You have a single transaction where you are mixing INSERT/UPDATE and SELECT? Be very careful that you're performing these actions in the same order or you'll be getting deadlocks all...

Don't use transactions on the read statement. There's no need for them anyway.

The statement you have there is an extended property. It doesn't create functions. Instead it is used to document and describe objects already created within the database. You can lookup...

You can check the @@rowcount to verify how many, if any, records were deleted. Or you can use the OUTPUT clause to capture specifically which records were deleted.

As Jack explained to you, without some specifics, there's almost no way to address your issue.

Speaking in general terms, using a cursor to select records is almost always a mistake....

I'm actually not entirely sure what you're asking. Do you mean something like: Always join on the key, the whole key. Or are you looking for tricks with XML execution...

jeffrey_bryant (12/11/2008)

---

Great thanks for the info. This really confirms what I had thought. Just wanted to make sure there wasn't a major gotcha someplace on this issue.

Unfortunately the Dev...

Got me beat. I've only been driving for 31 years. I've got the scars from the one major accident on the bike.

And even as you hit the limitations on a single table inside a single database on a single server, you can start to look at partitioning and parallel processing using...

It depends.

Is there going to be a lookup value:

08 A

As well as the value:

07 A

If so, then the year should probably be part of the PK of the lookup table...

Yeah, maybe that's what I read too. I know I saw that it's going to more and more standard, if not required. So I'm working it into my code now....

I'd say it's a good habit to get into. If you use CTE's you must use a semi-colon terminator on the statement preceding the CTE. Microsoft has said they're going...

Roy Ernest (12/11/2008)

---

Kishore.P (12/10/2008)

---

Gauthama Kolivad (12/10/2008)

---

Using the same DB... I mean without using backup ... we cant restore a stored procedure to the previous version.

As Gail Shaw mentioned if...