Yes I should go with Try, Catch but I was to loop so that I only commit so many records at a time.

I know that I still have to add the TRY... Catch logic but how else can I improve this code?

DECLARE @ArchiveDate DateTime

DECLARE @active bit

DECLARE @RowCount int

SET @active = (SELECT...

I need something like the code listed below but it has to archive, Rollback if there is an error.

Something very simple not.

The following code only deletes and there is no...

I will look into it further.

Thanks.

I prefer to have a control table where you lookup the batch size, several other other field to include an active flag.

If the flag is set to 1 it will...

Jeff,

That was a great presentation that you shared with me.

Until I can get a solid and tested plan I have elected to write a script to archive and delete the...

I clicked on it this time and opened as a new window and it worked.

Thanks a bunch!:cool:

Thanks Jeff.

When I click on the like it directs me to the main forum page.

I'm going to probably archive year.

Thanks again.

That is for the...

Jeff Moden (8/3/2015)

---

Welsh Corgi (8/3/2015)

---

Jayanth_Kurup (8/2/2015)

---

seems fairly simple , i would personally use partitioning since it handles the whole process with far less stress on the DB but it would...

Not it is not being used.

J Livingston SQL (8/3/2015)

---

as a...

No it has not been used.

I need to create a table and add a bit flag to stop the looping...

How is this?

Can you see how it could be Improved?

DECLARE @NextIDs TABLE(UniqueID int primary key)

DECLARE @ThreeYearsAgo datetime

SELECT @ThreeYearsAgo = DATEADD(d, -(3 * 365), GetDate())

WHILE EXISTS(SELECT 1 FROM [ISAdminDB].[dbo].[MyTable] WHERE [MyTable].[DateTime]...

The following code archives and deletes records. But it does not contain a while loop to limit the batch size for the number of records that are committed.

Any ideas?

CREATE PROC...