Thanks alot 🙂

thanks for your input - think i'll go with the sql express, sqlcmd route.

Have a nice day 🙂

Thanks. Creating a front end is no-go. Could I create a SSIS package to run the SQL and then get the users to execute that from their command line? Would...

I finally got my query working thanks to your help GSquared. 🙂

I had a problem getting it to work for ages after modifying it with the code you provided...

Hi Guys

I can't get the exists method to work because the data in my xml does not specify timezone. At least this is what I think the problem is. I...

WOW -thanks for that GSquared and for putting the effort into it. I'll give it a go..

Have a good weekend!

Here is part of the xml - the whole xml field is massive so cannot provide it all

<CustomerQuestions>

<Question...

Oh yeah.. thanks. Should have known that!

great - thanks mister magoo... it was driving me crazy!:-)