Okay, here is one way to delete five million rows of data from a table with thirty seven million rows of data.

declare @Batch int;

set @Batch = 10000; -- Batch size...

Remember always, the water cooler this is. Here may you veg (or my case run to the desert), rant a bit, and even ask for help on other threads...

If you're going to "bump" your post, how about posting something usefull, like DDL for your tables, sample data, and expected results. That may actually get you more help...

Dave Ballantyne (11/24/2009)

---

Its not just SqlServer central this happens with...

Just had to check my daughters homework (she 8) , she had to plan an 8 hour evening tv schedule adding...

Not sure, but I think I'd try something like this:

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

begin transaction

if exists(select 1 from dbo.tRunNo where Pref = '_T' and RYear = '2009' and RMonth =...

Ron-279530 (11/24/2009)

---

The query below return many records where the description field is identical, where that occurs I want only the most recent of those records.

select historyid, h.startdate,a.account,h.description,longnotes, address1, city, state,...

May I suggest that you try checking out BOL? It may cover this particular topic, I haven't checked myself as I have never been asked this question myself in...

Actually, if I were doing this and running a query through the end of the previous day, month, quarter, etc I'd do it slightly different.

Using the end of the previous...

First, this question could require an extremely verbous answer. It would help if we could understand better what you are actually looking for from this question.

So, yyyy-12-31, yyyy-03-31, yyyy-06-30, yyyy-09-30?

Then you can check this out:

select dateadd(qq, datediff(qq, 0, getdate()), -1)

This will return the last day of the previous quarter.

Okay, now it looks like you want the end...

Compassion

???

From what I have read SSIS 2008 packages can not be run using SSIS 2005.

Jeff,

Wouldn't a million row setup show what you are talking about? Of course, you could make it ten million.

I have to agree with Jack, Bob. Thank you taking that initiative to check on Barry. It definitely sets SSC apart from the rest! This is the...