Hi,

Thanks for your help again, this worked.

I just want to ask something about your code, in the following line:

...

Hi, Many thanks for the help,

I created the function and using the code below I am trying to create the IDFrom and IDTo, it seems to work but there is...

Hi Thanks for your help, I tried to put the code into a table function so I could test the CROSS APPLY, but I keep getting a syntax error:

ALTER FUNCTION...

mistake in message, should be -

"if ID = '4235_20d' the query currently produces the prev ID as '4235_10d' when it should be '4235_19d'."