I say again... Just like SQL allows itself to take any form... or Java... or...

I've seen some absolutely gorgeous VBS both formatting wise and code wise. I've also...

Grant is correct... great pains await you especially if you try to take any shortcuts. Whatever you do, make sure you have a viable backup table somewhere. You...

Adam Bean (3/10/2008)

---

Ok, I'm creating a couple custom proc's (one for 2000, one for 2005+), and I'm trying to figure out once and for all, how SQL determines the size...

Yeah... I wanna know to...

Simple way (although it uses cursors in the background), is to Google sp_MSForEachDB.

No, not really... only time I do it is if someone made an accidental cross join (for example) that caused a db to become over inflated. But when that...

Definitely not a trivial topic... and I haven't really found a good "starter" book on database design except for maybe some of the topics in Books Online. Before you...

No... not...

Thanks for the feedback, GoodGuy... but it's all the same... just bigger, that's all 😉

kent waldrop (3/11/2008)

---

After re-reading the exchange I think my question was wrong because I was focusing on the wrong part of the question. The orignal question, "... Is it...

Heh... yeah... they break the hell out of the 4k barrier of sp_ExecuteSQL and will return return codes just like the real ones. Neat thing is, if you need...

So, tell us what the trick is...

Yes... for example, see the following... it solves one of the worst performance problems in SQL Server that there is... Running Totals... will do a running total on a million...

You need to explain the rest... first row, even if you skip it, must have the same number and type of delimiters or the second row may cause an error...

Thought I'd answered your question, Kent... what were you actually asking?

Temporary stored procedures begin...