Ahh all is now clear - I would definately make the point that you may not be able to recreate the data to your client though - Just to cover...

Surely if you're keeping the original data and selecting it into a temp table, if the client asked you to recreate the data you'd have major problems. I would...

Are you reindexing ? that will cause the log to grow big

Vijaya - I'm confused why not ? Am I missing something

Just a guess but have you declared the variable @BOCLEARED ?? Just a hunch 🙂

Or if you have something like SQL compare make the changes on a test server and use SQL compare to do a comparison and script the changes out

I can speak complete rubbish and do most of the time 🙂

I'd like to say how refreshing the discussion on adding days was and I didn't feel that anyone was defensive in any way and nor should they be - whatever...

Presumably you're calling the sp MyStore from more than one place - so how about an extra parameter StoreInTables - set a default on this of 0 and if it's...

It was really not obvious what 'My store' was at just then - unless I'm being dense 🙂

Well I've been working for the same company (in UK) for 8 1/2 years and although I wanted out I felt that it was dangerous right now and that if...

Do you want all of the entries from these two tables or just new entries. If you want all of the entries like Grant says just use select into, if...

scalar value results:

500 rows: CPU time = 844 ms, elapsed time = 879 ms.

15,000 rows: CPU time = 25531 ms, elapsed time = 25603...

I really like that solution too Jim - really simple and yet so neat 🙂

I'd like to second what Derek says - it's been an intersting discussion

Cheers to J Gravelle

Andy