I surely can script out my tables etc. I figured you geniuses wouldn't need anything more than to see it to know where I am wrong.:-)

I was looking for something...

Hopefully I am explaining this in the correct way. What I am expecting is for my CTE to recurse through all three tables returning hierarchical data that I can then...

I expect it to go from one Try Catch to the next like this:

BEGIN TRY

SET @AcctNum = CONVERT(DECIMAL(13) ,@AcctNbr)

END TRY

BEGIN CATCH

...

I understand your points regarding where I had indeed misread my own code. But the code snippet I meant to post was this one where I don't seem to be...

Yes agreed. Problem is that it is all one one machine for dev, test, qa. Then it goes to prop on a different machine. They aren't even virtual machines. One...

OK so this might be something new to me. To clarify I am writing Sp's that are accessed from a business object in between dbase and web front end. I...

I agree an assembly would be the best approach. Why recreate the wheel and an assembly would be more globally universal for others to make use of as well. BUT...