I wasn't sure how work_ord_line_num played into this scenario, so I added some extra data just in case it also needed to be the maximum.  Try this: 

CREATE TABLE #tblBag_data_Deflash(...

My head is big enough... just ask my wife.  She'll be happy to complain about it to you. 

Heheeee.  I just learned that function yesterday myself!  SOUNDEX is a booger to use...

Don't let your head get too big - it is only once and while....  heheeee  (jus' kiddin'). 

I have had similar problems.  You could put it into a #TempTable or @TableVariable and use sp_executesql.  The problem often lies in the new SPID that is created when Dynamic...

I got this from Remi.  Its a pretty darn good function and the table Numbers is useful for itterating...

IF EXISTS( SELECT * FROM...

I would suggest the DIFFERENCE( character_expression, character_expression) over SOUNDEX.  It actually uses SOUNDEX, but it is more simple.  I would suggest building a cross-reference table using a match of only...

Sorry, I was gone for a while. 

Your number list does not sound too large to need a cursor.  I would see how the loop works. 

Change these to permenant...

I don't find reference to length that sp_executesql will accept.  I only that in one specific portion of this stored procedure - Steve and I went back and forth on...

What gets me is that is worked for months!  This is probably the most common of the hardcoded dynamic SQL used in this program. 

The place I contract uses a...

Try declaring @FY as a table variable.  Then supply your @Variable with that value and it should not return the Fiscal Year value...  

I know and I hate it when I find out it was that simple. 

Actually, this is one portion that is a "hard-coded" section of the dynamic sql, (it is...

You got it govinn!  I am an idiot....   

What I don't get is, why did this work for so long? 

Sorry for wasting...

I cannot get this to work yet, but I think this may be the approach.  The thing is, sp_executesql need ntext, nvarchar, nchar to work and I think the EXECUTE...

I imagine there is a better way to make a pivot table, but this will work.  Hopefully, one of the smarter folks on this site will give you a more...