Thanks!

That was a typo.

Yes, that was an assumption. Since developers normally face this when thier default database setting is set to something other that the one they want...

Have the below option in the begining of the script, i.e before calling the SP. This defaults the the provided database name & you do not have to give...

Try this below statement.

Please note that there is NO WHERE clause; this will give you all the combination.

Insert into clientVendor

select cientId, vendorID

from vendor v

, client

Any luck on converting table variable to temp table?

Here are the other action you can try.

* Recompile procedure (Oh yeah, sometimes this works magic.)

* Gather statistics on the tables included...