I know that a CTE is only used in the following statement, but in this case I have 2 CTE's defined (the 1st feeding the 2nd). The INSERT statement...

I realize that it's quite local, but the problem I have is that within the CTE is a recursive call to the same UDF that has the CTE. Therefore,...

I just did and you wouldn't believe what I discovered! :hehe: Apparently, if the SP begins with anything else other than "sp_", then I can't run it in...

I was trying to avoid that if possible because the entire SP relies on being in the correct database. If it's not possible to switch the database within an...