I see the irony. But I truly believe he's turning his act around so I stopped pounding on him :-).

I generally do create table, create indexes, then insert.

SELECT DISTINCT *, IDENTITY(INT, 1, 1) rowid INTO #tmp2

I've never had that error. Google wasn't helpful?

So much simpler!!!!!!

Can't you have this multi-select parameter nullable in SSRS (never tried)?

Either that or select all regions by default.

Identity columns could do the trick, if not that then row_number()

I would presonnally make a procedure on the server. Add a button to excel and simply code the dataset call there along with the presentation. It gives you...

Nice parabol. :hehe:

I'll keep following along but I have nothing <else> of value to offer except maybe a good luck or 2.

skcadavre (5/18/2011)

Had you written that the first time I wouldn't...

For #2 the optimizer is smart enough to understand what you're doing. There's no point in giving the same command over and over again.

I've heard this myth too and...

Select into could cause recompiles and slow you down.

I only use it in dev mode where the list of columns is ever changing. Then at the end of the...

Ok now that's 3 of us. Reallllly getting freaky here :blink:.

hopefully gail has another train of thoughs on the rails for you!

Is there anyway to add 2 steps to that process?

Transfer the fulls backups and start the restore.

Now once you're close to being done on the restore start a diff backup......

Wow that's a scary thought. A problem that both of your brains combined have troubles dealing with :w00t:.

I never thought I'd see that day!