Can you post definitions for 'table' and 'another table'. My guess is that they have a SQL_VARIANT column and you are push it into a NVARCHAR variable without explictly converting it.

http://msdn.microsoft.com/en-us/library/ms187928.aspx