I have 2 databases on the same server. Lets call them db1 and db2. Now I have a user defined table variable that is called u1 which I created on both the databases.
I have a stored procedure (p1) on db2 that takes u1 as a parameter which I want to call from db1. So I call db2..p1 @u1 = @u1 and then I get the following error:
Operand type clash: u1 is incompatible with u1
Is there a way to get this working?