It's early in the morning (pre-coffee) but where do you construct the xml?

I really like this a lot, Oleg!

And Florian, a pity your script went largely unnoticed - you should have submitted it as an article!

Real shame about the 4000...

Got to be a bit careful with isnumeric as ISNUMERIC('12345e1') returns 1

I think you can use something like

isnumeric(right(myfield,7) +'e1')

Regards,

David.

Thanks Mark,

That's an interesting approach certainly with merit. It got me thinking about an alternative which would "bubble" non nulls to the top, by linking to the previous row[/url]

Do...

Please correct me if I've misunderstood but....

Coalesce returns the first non-null value among its parameters (from first to last). Given that your second parameter is

not null (a space),...

Thanks for pointing this out and including...

Looks to me like you've pretty much covered the A-Z of the subject.

Well done!

I never realised, for instance, that temporary tables are still in scope to nested procedures. I'm...

mcl (5/18/2009)

---

A great concept, excellently packed and ready for use out-of-the-box.

Reading the article sparked off an idea but, as I'm relatively inexperienced in working with SQL server & XML, I'm...

Simon Taylor (5/12/2009)

---

Nice example, David. I developed a complimentary set of audit functionality that audits data changes themselves a couple years ago for SQL Server 2000. I ported...

Paul White (5/11/2009)

---

Hey David,

Point taken - and I agree it is a good...

excellent! enjoy!

Nancy,

It looks to me that you've not set the OperationType correctly in the XML task. (Your doing XSD validation instead of XSLT.)

I've attached a screenshot of how the xml...

Hi Nancy,

I'll try to check this out this evening and send you some feedback. (It's afternoon here.)

Regards,

David.

(Alternatively checkout MSXSL from the Microsoft downloads pages.)

We McKinney's have got to stick together! (I thought I was the only one in the SQL world!)

Thanks for your support.

(And yes user name is an obvious extension to...

Thanks for your comments.

I agree - it is highly dubious! But hopefully that doesn't make it without merit.

In Part II, I do talk a little (just a little) about...