Hi. I'm grateful for the reply but I can't seem to see any particular changes to the result set?

For the chain that starts with shopID 1875 the currentID is still...

Hi. I'm sorry about the messy post. Here is a script that I think conforms to the rules of this forum:

--===== If the test table already exists, drop it

USE [vptjTemp]

GO

IF...