File purge maintenance plan

Question

File purge maintenance plan

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004405 More actions · Answer 1

igloo21 (9/12/2009)
That's because Oct 31st falls on a Saturday 🙂
The all the file types are prefixed as cur*.txt
The calendar table already exists as dbo.tblAcctPeriod
Thanks!

Thanks, but not of that really tells me anything useful. Here's what I asked for before and I still need it to help.

Please post 4 different file names that you wish to process. I also need you to post the CREATE TABLE statement for your calendar table.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

igloo21 Mr or Mrs. 500 Points: 534 More actions · Answer 2

igloo21

Mr or Mrs. 500

Points: 534

September 12, 2009 at 2:16 pm

#1052737

.

Jeff Moden SSC Guru Points: 1004405 More actions · Answer 3

Heh... Not sure what it'll take so I'll ask one more time for you to help me help you... please post the CRATE TABLE statement for the calendar table and be sure to include indexes and constraints.

Also, the data in the spreadsheet is not readily consumable by most folks. Please read and heed the article at the first link in my signature below for how to post readily consumable data. Folks will likely jump through hoops as well as providing a fully tested solution for you if you simply take the time to help them a bit.

I'll check on this tomorrow night... I'm nowhere near an SQL Server for about the next 30 hours.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)