Just edit the statement to use NULLIF for the cases when there are no blocks:

SELECT @SqlStatement = '

UPDATE lo

SET lo.wait_obct = obct.obct_name

FROM #res lo JOIN (

' + NULLIF(@SqlStatement,'') + '

)...

This was so long ago that I'd forgotten. It's been answered elsewhere but here's the gist of the explanation: user defined data types and table tables are CLR objects(compiled code)...

I'm having the same problem.

I'm trying to use a table-valued parameter between two databases. I created the table type in both dbs (here called CallingDB and OtherDB) and they...

Elisabeth and Jerry,

Thanks for the reply. I'm trying to do an upgrade.

I'm trying to install version 10.00.1600.22 "Microsoft® SQL Server® 2008 Enterprise Evaluation: Trial Experience for Developers". Trying to upgrade...

Jacob, thanks very much for the post!

I killed many hours searching the MS sites, blogs, forums, etc and was up and working minutes after reading your post.

where'd you find it?

Mike,

Thanks for this tool, it's quite useful. It appears that the 'PH' replacement portion needs a fix too.

-- this part works (it makes a 'P' into an 'F')

   } else if...

Your problem is in the string you're creating - it's trying to implicitly convert a numeric to nvarchar (I assume that's what your using for the variable @SQLViUp).

Try casting the numeric...