I'm young and I agree .

Select col1, col2, coln, 0 as id into #table from dbo.atable where 1=0

BTW, DON'T DO THIS in production. It's cool for a one time copy of the table, but...

Yup, see you tomorrow.

Alright... what part took a minute to soak in??

I don't see why I would use that, it's just a custom datatype, nothing more.

Still pretty young. Wouldn't wanna try that at 60 .

Get a copy of the query that is being executed on the server... there's most certainly a stupid syntax error in it (test in query analyser).

Also here's the equivalent vb...

24. I finished my 1 year course 14 months ago. Been a programmer/dba/network/helpdesk/analyst at the same job ever since.

That would be another major Whoops...

Can we delete this file without breaking the system?

That's your problem. If you read correctly I almost only answer to questions. I posted 2-3 questions when I joined and I also posted a challenge. This...

Have you seen any use for this (besides for the system tables)?

How about this??

"SELECT DATEDIFF(minute, '" & DTSGlobalVariables("RefreshStartDate").Value & "','" & DTSGlobalVariables("RefreshEndDate").Value & "')"

14 months old here .

Don't know your system enough, but you seem to have categories, but you also seem to have types of...

If you don't want to rerun the query for performance, then you can always create a temp table to old the results.

Insert the results in the temp table.

Select the #temp...

That doesn't make you old... unless you started at 40 .