Great question.. nearly missed the zero myself!

Very good question, I got it wrong because I didn't pay enough attention to the question! lesson to self.

I agree with Hugo. I thought of a couple of ways this could be done in my head before answering first, but didn't bother trying to research any other ways.....

Nice question. Surprised at the number selecting '0' as an answer though. 32% presently.

As Mark stated, there is no easy work-around. However, I have had to do this myself in the past and the way that I solved it was by using XQuery,...

That's great! Glad that you was able to achieve what you needed too. Sorry I've not replied before now but Ive been enjoying a nice break in Scotland.

Pivot'ing is...

I think the problem is with the order by clause. Try changing this to order by Tag first and see if that helps.

Not an easy one.. I have come up with this rather crude way of creating the xml that you require from that data. This isn't great and it isn't going...

jwmott (6/12/2012)

---

excellent. thank you. so it appears that I should use type string and validate using regular expression as I just can't get non string data types to...

I think the problem is around the namespaces. I have updated the code to the following and i think it works how you need it to:

-- DROP the previous SCHEMA...

No problem.

I did spend a few minutes today and came up with the following rather simplistic/crude script which may offer some kind of option for you. I don't really like...

Unfortunately, using tsql, it isn't possible (easily that is) to add an attribute into every child node as the target of an insert operation needs to be a single node.

Personally,...

Here you go, this is a slightly revised version. I just removed the inner join from the first query and added Tag to the order clause. The join was adding...

Ok that looks like to me that the contents of that field is changing before getting to that point in the code. Im fairly confident From what you have posted...

What we would need to do is to slightly change the way that the stored procedure is being called from the asp page. You've not posted how the connection to...