Thanks,

That looks good, I think I now have some answers to go on with.

Regards

Dave

Hi Thomas,

Yes, the previous code suggestions sounds feasible. That might be the left field kind of suggestion I need. I definitely want to avoid trawling manually through 3...

Thanks GSquared,

I'm using SQL Server 2000.

I don't know what a standard recursive CTE is? That's why I'm posting in the Newbies group.

I agree that I need to get a...

Thanks Steve,

In fact thanks to all those who have replied. (There's not a "reply to all" option). I fear there is no quick fix to this. As...