I don't think it looks bad, it does what you want.

Your only other option is to always use OUTPUT into a table variable. Then test the logging flag after the...

ScottPletcher (6/6/2012)

---

DECLARE @deleted_ids TABLE (

license_message_id int

)

BEGIN TRY

BEGIN TRANSACTION

DELETE FROM

dbo.license_message

OUTPUT DELETED.license_message_id INTO @deleted_ids

WHERE

archive_date...

Okay, I understand your set up now. The clustered index is on the id.

I'd try to do it this way:

--

-- get a consistent snapshot of ids to be deleted

--...

Is the clustered index based on some sort of chronological entity that is also a factor of your deletes?

For a scenario like you just described... rows inserted and rows aged...

MisplacedChildhood (6/4/2012)

---

I think I fall into B). I would have said A) 2 years ago, but things have changed. I've found that the hard work I do sometimes...

I'm right at B. I like it here and the people but I'm underutilized in terms of my technical skill set. While not underpaid per se, I'm interested in more...

mtucker-732014 (5/29/2012)

---

I think that of all the things a company can do to attract and keep good employees there is one universal truth - if you dont pay good people...

Just use the import data wizard. You can import directly into an existing table or to a temp table and then insert to the existing, whatever you prefer.

Just right click...

I watched "The Thirteenth Floor" on Netflix really enjoyed it, though it is a couple years old. I'm not usually into Sci-FI movies but this was more Computer-Techi than Sci-Fi....

Sean Lange (5/25/2012)

---

I can remember on many occasions when it was windy we would fly backwards. Just pick a spot and point straight into the wind, slow down to just...

Its all about the journey, not the destination. That's the one downside of flying fast: Its cool but its over all too quickly.

Fly Girl (5/24/2012)

---

And first to the important stuff: sturner... Does this mean you are trying to slow down or that you are trying to see what's in front of you?...

If you could provide a complete listing of the code in the procedure that might be informative. Also, as someone else suggested, is everything in the dbo schema?

I'm sorry you have to deal with this crap. It is the result of a VB programmer gone wild with a database to play with. Sorta like giving a machine...

You would certainly want consider that metric, but understanding the database design (or lack thereof) , database sizes, type of transactional activity and the nature of the applications. Batch requests...