Nullable columns it is. It's not so much the data integrity that bugged me, it was scalability. I don't like the idea of having a table that has...

SELECT [ACCOUNT #], MAX([DATE]) FROM PAYMENT_TABLE GROUP BY [ACCOUNT #]

That would get you a result like the following for the above data:

123456 8/9/04

123457 5/19/04

If...

I hope it's open source, because there are several things that need fixed. In my 5 or 6 posts here, i've had a couple just clear and disappear when...

Never used cubes, but in Sql there is the datepart() function.  You can get the week for anydate like so:

select datepart(wk, '3/25/2004')

>> 13

Apologies if this isn't in the realm of...

To delete records from PROD for matching records in AUDIT, given the constraints I listed in the original post.

Thanks for the responses. The structure is already hardcoded, so i'm trying to get away from that.

I have one additional issue, and I believe it will fit...