HI Joel,

I tried the suggestions that you offered. I tried to incorporate the @TotalVotes count as a subselect but I keep getting errors. So I came up with the following:

I...

Hi Joel,

Thank you for the answer. I'm getting a little confused with the logic and I was wondering if you could help me finish it off please.I used the left...

hi there,

it's this nref.value('eta[1]', 'smalldatetime') AS ETA that giving me trouble. The query works up to the point I need to insert some dates then it all falls over. The...

Hi There,

here is one product from the table, I hope you can help me with this.

thanks again.

<product>

<status>UPDATE</status>

<stockCode>DVAHISX</stockCode>

...

hi there,

I tried to the syntax that you suggested and I got the following error. The column is actually smalldatetime, I forgot to mention this orginally.

nref.value('eta[1]', 'smalldatetime') ETA

(1 row(s) affected)

Msg...