Hi

The query before the IF statement may return no rows. In fact, more often than not, it will not return any rows at all. When it does return no rows,...

Hi. Thanks for the quick response.

The stored procedures are not replicated. They reside on the publisher and are executed against the database on that server.

The Ins_CreatePart is fairly straightforward:

CREATE PROCEDURE...