As a general rule, Access writes its queries through Wizards from the inside out, (hence the RIGHT JOINs - which always throw me) but they often work for SQL Server. ...

Uh, uh..., I know.  It cuts off the rest of the characters and you are @#$%.  Right?!   

(You may want to consider...

When you "assume"...   

What problem are you having with the @@GlobalVariable? 

This approach will allow to parse through each value within your existing SP.  I personally would suggest using the pipe [ | ] as that is a very uncommon delimiter...

Do these fields relate? 

Table1

(PK)DocumentHeadersID int 4 0

 FileHeadersID int 4 1

Table2

    (PK)DocumentTransactionsID int 4 0

    (FK)DocumentHeadersID int 4 1

The GO was missing.  Did you just add that along with the comments? 

Thanks (great solution...). I was hoping to be able to do this without having to loop through...

I get an error: Server: Msg 156, Level 15, State 1, Procedure nmbPadd, Line 72

Incorrect syntax near the keyword 'declare'.

This is not dealing with the Alpha characters well, (I threw this together), but it might help someone smarter than I to get their brains working: 

CREATE TABLE #Sort( [Value]...

ROLLBACK

COMMIT

REPLACE

(these could also be like Chinese fortune cookies and all you need to do is add "in bed" to the end...). 

I thought I'd get a rise out of you saying 'pretty'.  Its actually an excellent track record. 

It may well benefit you to give us the context, etc.  rgR'us has a 'pretty' good track record. 

"Any society that would give...

I agree with Lee.  This will cause you a great deal of difficulty down the line. 

I also agree that I liked Lowell's approach... ...

You will probably need to use Dynamic SQL (either EXECUTE @sql or sp_executesql) .  But, please read the following before you attempt this. 

http://www.sommarskog.se/dynamic_sql.html 'The Curse and Blessings of Dynamic...

gotta love that sushila!!  

Do some of your records have desp_day?  In other words, will you only be updating those records which are NULL, or the entire table?  And will this be part of...