Just one note for the naysayers. This relates to the OP.

I LIKE using SELECT *, since it allows full table data to be funnelled seamlessly up (along ?) through...

Jeff

Example of dynamic SQL forcing global cursor (this one is from a metafunction library, but it demonstrates the idea).

exec sp_lib_KillCursor 'fetch_cursor'

SELECT @s-2 = 'DECLARE fetch_cursor CURSOR...

GilaMonster (9/8/2009)

---

ben.mcintyre (9/8/2009)

---

I badly need my views here. Due to the size of the data chunks I'm dealing with I have to wrap them in views to stay sane....

> Maybe it simply isn't apparent to you. You have changed the information and options available to the optimizer in a very

> complex construct. It does what it can...

Thanks, again, for your replies.

Yes, I was worried that I might be swapping one set of fast and slow plans for a new, different, set of fast and slow plans...

Hmmm ....

The silence in this thread is almost deafening.

Was it what I said about being Australian ? Those bloody 'Flight of the Conchords' guys have been giving us a...

Funny, but this instantly reminds me of all the other flavours of database in the world, running under *ix... Postgres, MySQL, Oracle, ...

It's standard practice to have a totally stripped...

Just wanted to say thanks in advance, I really appreciate any time anyone spends on this one.

I've combed the internet for years over problems like this and been completely unable...

STATISTICS IO and STATISTICS TIME

See Attachments

OK, here are the plans and a database diagram (attached).

I have simplified the query a bit, but unfortunately as I take bits out, it all runs fast and the problem...

Thanks for link. I'll post the plans in another day or so.

Yechh. I remember tearing my hair out over MDW's.

Anyway, the most important thing is: who (as in which user) is the Owner of the database ?

You should be able...

Yeah.

This might be a bit off topic, but this discussion reminds me a lot of reading Larry Wall's comments on PERL. PERL has a lot in common with SQL,...

There are some really weird things going on here.

But

Convert.ToInt32( AccountList[LoopVar] = i );

is dead...