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...

Thanks Phil... guess I'll just keep doing CPR (Cut, Paste, 'n' Replace) using Word until they fix the forum code... I just copy from QA into Word and replace all...

Jay H (10/16/2007)

---

I understand what you are saying.

And I apologize for not being more clear.

My primary key is a true primary key in another system. Instead of truncating the...

They don't show if you copy and paste into Query Analyzer...

Perfect... the rest of us can ignore you then.