it's Common Table Expression. you can set up a statement that will pull a result set that you can treat as a table. see this link:

http://msdn.microsoft.com/en-us/library/ms190766.aspx

seems to me this would be a good application for a CTE

Greg -

thanks for that. I think the /!Y switch previously mentioned is actually to take it the other way - CREATE the encrypted string from parameterized DTSRun...

I read a good article on this at TomsHardware.com a few months back. I just looked at their homepage and they have a link devoted to SSD storage. ...

COOL! Is that in BOL? someplace where I can look to check exact syntax and usage?

never mind....I just googled and found several useful pages. Seems MS encrypted the...

OK, thanks. I'd be happy to look it up myself, but don't really know where to start to look.

The not being able to identify the DTS package that a...

that's the part that's really confusing me. I can create a new job scheduling a package to run. Then do it again using the same package but the string...

when you use ODBC to link Access to SQL Server tables, you MUST choose a primary key in the SQL table or they will come up RO.

Jeff made the point I was going to... this has been referred to as a data explosion and I can think of no use for the results.

Are you sure that...

my 2 cents.... Jack's idea of parent/child user/payment is the way I'd go. This will retain payment history which someone is sure to ask for. however, you still...

I thought this topic sounded familiar:

http://www.sqldev.org/sql-server-database-engine/prevent-select--query-80094.shtml

given your current table structure, you can't reliably find records inserted for any time period.

IMHO, to copy all data from one table to another that doesn't have the same fields or field names in a generic loop would require some pretty complex coding involving...

g'morning -

there doesn't seem to be any duplication for counter/field pairs. I believe the problem is that there is no field that is guarrenteed to have...

GSquared -

I've been playing around with your code and seem to be running into a problem. Here's the fleshed out version for the test data that I posted

SELECT

...