Split "functions" are nothing more than RBAR... and the...

Derek Karpinski (10/17/2007)

---

Point is that those precious DBA's are going to have to shift to the real world sometime soon..

I'm a DBA and a Developer... Accent on Developer.. 34...

Thanks, Noel... that's why I like this place... I learn something new everyday 🙂 I'll check out BOL on that. Thanks again.

Heh... like I said, Derek... CLR's are for people who don't really know T-SQL... 😉

If you have a GUI involved, that type of formatting should be done in the GUI......

Sandy (10/16/2007)

---

Hey Grant & Jeff,

I think you both are concentrating multiple table updates

rather than Nested Update Statement,

I clearly mentioned that I have used Nested Update statement

rather than Multiple Table...

Creating the view is fine.... but it won't help you update multiple base tables with a single...

This type of formatting should generally be done in a GUI...

However, it can be done in SQL Server... lookup "Cross-Tab Reports" in Books Online for a complete explanation of how...

Grant is correct... you can update only 1 table at a time... you will need two totally separate updates.

Thanks for the feedback, Jay... if you get a chance, let me know what your timings are. Would really appreciate that...

Matt Miller (10/16/2007)

---

Ahh - that explains it. That's one of my rules of thumb - "when dealing with a dangerous manager, make up a highly obscure technical reason, and...

SQLMAIN (10/16/2007)

---

ISNULL(@SQL1+',','')+CHAR(10)

Just curious - what does this line of code do and how?

Noticed that if this is not there we just get one row but with this we get all...

My pleasure... thank you for the feedback...

Jason Selburg (10/16/2007)

---

They do on my machine.

Wait, do you mean Query Analyzer or Management Studio? They show in SSMS.

I can definitely see that Steve and the guys need to...

Matt Miller (10/15/2007)

---

...which of course, would be true if you inserted ANYTHING in there instead of CLR. Try replacing CLR with: cursor's, UDF's, CTE's, T-SQL, triggers, jobs. As...

Possibly, David... in most cases that I've come across like that, the multiple procs were actually written (initially) to support the natural RBAR that occurs in GUI related code... such...