Cool... but it's customary to thank folks by posting the code that you used to make it work 😉

Heh... how quickly you all forget... there were TWO of the bloody damned things 😛

C'mon... you know better than to make us ask you for the table/column schema... it looks like your dates are Integer based, but who can tell??? :blink: And,...

What are you using to do the actual export?

You could start by running sp_Lock during the periods of slowness. Running sp_HelpDB will allow you to figure out the DBID for TempDB... check for blocking on that DBID...

It was a way of saying "Thanks, Steve". I do it the same way Remi does...

Any luck yet on the triple spacing problems I told you about or...

Heh... I know that's gotta be right... just inserting 1 row into a brand new copy of the table gives me... (note that I run this type of code in...

And, here's a good article by the gent that got me interested in Tally tables a thousand years ago... just remember, he doesn't really explain how to do the "business...

Like any other function that returns a table, you should be able to use the function to create a permanent table...

[font=Courier New]

SELECT *

INTO dbo.newdatetable

FROM dbo.F_TABLE_DATE(somestartdate,someenddate)[/font]

My concern is... what do you...

Guess I get to put the bat down... 😀 Separate tables.

One of the recommendations in Books Online under "deadlocks, avoiding" is...

Keep Transactions Short and in One Batch

A deadlock typically occurs when several long-running transactions execute concurrently in the same database....

And, lookup "parameter sniffing" on this site or Google...

Like everything else, it depends...

It's easier to maintain security differences on two procs if you only want certain people to be able to use the "full-details" version. If you...

I agree with Ed... sure, you should be sending backup tapes off site. Sure, you should save some text files and send them offsite. And, I agree... what...

Adding an Identity column to each table isn't that much work if you write a little dynamic SQL to do it for you... especially if you have it all worked...