I assume the table has a timestamp of some kind on it?

If so, create a SQL Agent job with a T-SQL statement in it that DELETE FROM table WHERE timestampCol...

You're going to have a tough time with doing this *and* keeping it optimized. Pretty much a one or the other scenario.

The other difficulty you'll have in this is...

Check this post out:

http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/3fb29035-9f58-49ee-b6ef-6cd12a76bb59

You need to use SSMS SP2 CU5...

I agree with Celko on this one. You haven't provided us enough of the business rules to know how you do your rollups on I into S and rowId...

Sure there is, watch:

CREATE...

No problem, my pleasure. 🙂

The GOs are just there to build the CREATE PROCs.

The key is that Proc2 calls Proc1, which like any proc could be fed parameters and the like.

You'll have to be...

Silly question, but what are you trying to connect the '05 to the '08 with?

Linked server? SSMS '05 looking at '08 registered servers? SSIS?

Um, you mean something like:

CREATE PROC Proc1 AS

SELECT 'Proc1' AS Procname

GO

CREATE PROC Proc2 AS

SELECT 'Proc2' AS ProcName

EXEC Proc1

GO

EXEC Proc2

@tmitchelar,

I agree with you it's possible, but the 4.xml statement was the one that got me. He's overloading the load with multiple types, which is gonna go ugly. 🙂

The...

I broke this into ctes to make the logic more obvious. I also added a few entries into H111 to allow for multiple minutes over 60 to force a...

I think you're looking for this (Please note how I adjusted your build to create the full test script):

DECLARE @MyTable TABLE ( FirstCol VARCHAR(50), SecondCol INT)

INSERT INTO @MyTable (FirstCol, SecondCol)

VALUES...

Personally I'd use a method I typically take with HIPAA data and swap everything identifying a company/person into a GUID, and populate that GUID out to everywhere that references. ...

Well, that all depends on what "position" Wayne was aiming for. If he was combining the two concepts at once, he might...

Two approaches.

Entirely within SSIS: Use multiple sources, one your flat file(s), the other the target table in the database. Bring them both through a Merge Join to detect for...