Beautiful. Thanks for making the effort. I can see what you're after now. Answer soon come.

Is anyone else having trouble posting this morning?

Steve, I have an answer for the OP in this thread and it won't post my reply.

Chris I looked at your code, but I'm afraid I can't visualize the results you want from the description you gave. (It's late and my mental telepathy is breaking...

Don't be confused by a limit on how much of the data you can DISPLAY at one time. That may be a setting in SSMS.

Add a PRINT @@rowcount immediately after the SET statement. Bet a nickel that it is greater than 0.

If so, think about *why* and let...

He's right, it's much cleaner if you can use NULLs instead of spaces to denote absence of value.

Thank you, Mr. Celko. Or may I call you "Ming"...

GilaMonster (9/29/2010)

---

Grant Fritchey (9/29/2010)

---

GilaMonster (9/29/2010)

---

Just found out that the PM promised the users that they can see the reports on monday (as in next week). Fat bloody chance in hell,...

Dates in XML are just character strings. Everything in XML is just a character string.

replace(@XML,'23-Aug-2010','24-Aug-2010')

replace(@XML,'2010-08-23','2010-08-24')

A simple way is to simply CAST () your xml as VARCHAR(MAX) and then use the REPLACE() function to make the substitutions you want.

declare @xml xml = 'your example above'

select...

You're very welcome. I would be interested in hearing the production volumes you are running through this and how it performs.

Best of luck...

Jack Corbett (9/29/2010)

---

Thanks for your thoughts on the "maverick" coder. Unfortunately I don't have the authority to remove the person or force conformity. I have brought up the...

Alvin Ramard (9/29/2010)

---

Last night, someone posted an interesting comment in a new thread, in a non-database related forum, that I follow"

"So I feel there needs to be a thread for...

It's remarkable how many people don't get the concept that the manager's contribution to the team effort is support. The best managers I've ever had shared the view...

Sorry not to be of more help. Good luck to you, Robert.

Not me, Jason. Heck, I don't even like the taste of persimmons.