I am looking to start 70-462 course and was considering paying for access to labs to work through the book but I will be looking at implementing this....Fantastic article!

Can't wait to read the next instalment! This is precisely what I have been looking for.

Hi,

I was trying out your suggestion using the orthwind dbase. I have created 3 datasets.

Job_Title

Territory

No_Of_SalesReps

How do i use them within the fourth dataset? Perhaps i picked you up wrong...

Tanks for the quick response, I'll look into.

E

Yeah thats why i did the casting, it helped. but maybe would be ebtter to use proper data types in future.

Hi,

I agree but when i mentioned this i was told it was from an older system. xml data type would have made more sense.

Cheers guys, you have been a lot of help it's working now.

Kind regards to you all

E

Here's a more accurate copy of the xml i need to xquery.

I take it you guys are based in the states then?

Yep, Glasgow, Scotland. Didn't realise that America had a Glasgow.

cdata is abbreviation of what the tag actually is. cheers.

checked spelling. i must be something else. this is my first foray into xquery. cheers for the help. if you're ever in glasgow let me know i owe you a...

I sent you a simplified version of what was needed. i've reworked what you sent and i am now getting nulls in the columns returned. it's still a breakthrough. COuld...

here's a sanitised version

CHeers,

This looks promising but is not return the contents of the node. The return columns are blank although data is in the table that it is coming from.

cheers again, this...