I have already posted a reply but as often happens with this forum it just dissapeared

So here goes again...

I had a similar situation...

My change looped just 4 times not 10 though as I used count distinct on parentid. but I do see your point.

Thanks

Old hand posted what he described a a lazy option, I changed the code slightly to use a count of the levels available, therefore limiting the loops as follows

declare @idxcount...

If you are referring to storing the scripts in a table as above, use a text (Memo in MS Access) column for the script,

Text: Variable-length non-Unicode data with...

I just tried to reply to this and everything disappeared so here it is again!

I have tried a couple of methods using ADODB Command Execute method and found that the...

It worked! and has saved me hours of work on over a thousand columns across dozens of tables.

Many Thanks!

This looks like it works but is very basic with no error handling. I have not fully tested it but am happy with it

CREATE FUNCTION CalcIt (@calc as nvarchar (255)) ...

Can't see my last reply, perhaps I did not actually send it, Anyway thanks for your thoughts. The problem is based on having...

Unfortunately I cannot join the table in any other way, I will use VB instead, however I did not know why it was...