Heh... even better... nicely done!

Do NOT use ISQL!!!  It is severely deprecated compared to OSQL.  I'm not even sure why they left the bloody program available.  And, don't confuse ISQL with ISQLW which is...

P.S.  And, you don't need to see the KEY in this case... the report not only tells you which proc is doing it... it also tells you the line numbers...

Isolation levels may help, but the real problem is going to be in the code.  If you have explicit transactions that look like the following, you may want to consider...

4 day work week... would cut my hours from 60 to only 48

Perfect...

OK, Molly... I just gotta ask... you mean to tell me that you tried a command, that you got from somebody, on a production system without looking it up in Books Online?...

... and it will allow index SEEKs

DECLARE @MyRows INT 

SELECT TOP 1 SampleUnit_ID FROM #Sps

SET @MyRows = @@ROWCOUNT

IF @MyRows...

Heh... I don't know where they came up with the idea that SELECT INTO is slow... especially if the target DB has no triggers or keys and especially when the...

I'm thinking you need to post the SP_Generate_Inserts proc... let us see what we can do to make it less RBAR dependent...

Heh... not according to BOL which states (no sign of PATH anywhere)...

Basic Syntax of the FOR XML Clause

The basic syntax for specifying the XML mode in the FOR clause...

Surya,

Notice the following lines...

BULK INSERT dbname.dbowner.tablename  

FROM '\\machinename\path\Sample.csv'

Did you make the appropriate substitutions for the lower case items?

You bet... let us know if you need anything else...

I think the "hard part" isn't coming up with the fine code you guys already did, Brandi... the bugger is coming up with all future dates and times for a...