Ok. Thanks guys.

If you use an alias od.orderid it still lets you do it & the overall code still works & returns no rows.

You would hope to spot...

Fixed it.

Runningvalue does work across columns or rows in a matrix.

It just seems that you can't do it across columns AND across rows IN THE SAME MATRIX.

Thanks Chris. I think you have done enough already 🙂

Thank you to all.

In a fit of inspiration I have come up with my own solution. Although it gives a slightly different result set, I'd be interested in more...

CDC is fine for tracking DATA but what about WHO changed it? I can't even seem to write a join query to show the changes to the data by who?

Back...

Thanks to those who reminded me that this is ultimately just a gaps & island problem.

In reality I was only interested in Fridays so all the dates are 7 days...

Oh,

and just to make life even more interesting I forgot to say the dates are only ever Monday through Friday so a sequence of 1's may have to...

Have a look at the excellent xml tutorial on http://www.w3schools.com

Thanks for your help Wes. I'll bear dtcping in mind.

I've now rebuilt the servers and restored the databases & it's working fine.

Thanks anyway

exactly.

windows 2000 servers in a 2000 domain - not clustered

wow.

Thanks Nicholas. Looks good to me.

both sql 2000 servers in same w2k domain using same domain service account for sql server service and sql agent service. Interestingly it doesn't make any difference if I use...

here's the error message. The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.[OLE/DB provider returned message: New transaction cannot enlist...

this seems to work

http://databasejournal.com/scripts/article.php/1497761

but is there a way of changing the underlying default so I don't have to run a convert?