GilaMonster (10/24/2011)

---

thulani.moyana 79207 (10/24/2011)

---

I'm wondering why the single exec('Use database') does not affect the statement immediately after it as I would have thought it is executing on the target database...

That's not an error... just a warning.

Split the values with this, then only get the value you need.

http://www.sqlservercentral.com/articles/Tally+Table/72993/

... and that's with ONLY 1 table and ONLY 20K rows.

Try a 10 tables inner / outer join, optional filters and 20 M rows.

That performance's going to suck BIG TIME....

Way out of my league... can't help you on that one.

k, I can't help without seeing a little more what you need to do.

P.S. Unless your data structure is the next mc2, there's usually no problem in posting snippets on...

That way clear enough english... 😉

Then post what you have. I can't generalize on this anymore.

Merge might be what you are after in case you want to look that up.

Never hear that term. What does that do?

I'm thinking cube & analysis services right now in case you want to research that briefly before you next post.

You need a series of ifs for this.

It's not like you were doing

case Cola

WHEN 1 then select from table2

when 2 then select from view2

And even if a case like that...

bitbucket-25253 (10/22/2011)

---

sqlguy-736318 (10/22/2011)

---

Thanks Ninja - I assumed that table variables would always have better performance than temp tables but based on your emphatic NOOOO it sounds like you have a...

sqlguy-736318 (10/22/2011)

---

AccidentalDBA:) (10/22/2011)

---

Depending on what you are doing i like to user variable temp tables, there is no need to drop them at the end because once the script as...

sqlguy-736318 (10/22/2011)

---

Ninja's_RGR'us (10/22/2011)

---

AccidentalDBA:) (10/22/2011)

---

Depending on what you are doing i like to user variable temp tables, there is no need to drop them at the end because once the script...

Well you can execute a query in the case... which is rarely the best way to go.

What do you need to do exactly?

sqlguy-736318 (10/22/2011)

---

Thanks Ninja - I assumed that table variables would always have better performance than temp tables but based on your emphatic NOOOO it sounds like you have a lot...