The table name is "Communications" and so the SP name that it generates is "communications_IU" which is fine, however the update statement uses the SP name instead of the table name in the query.
eg.
Code: Select all
IF EXISTS
(SELECT * FROM dbo.communications WHERE Pk = @Pk)
UPDATE communications_IU SET
Direction = ....
Code: Select all
IF EXISTS
(SELECT * FROM dbo.communications WHERE Pk = @Pk)
UPDATE communications SET
Direction = ....