I want a table to store any data that could not get upserted
and I need to get a record count for updating my table…see query:
if @RecCount > 0
update NavSync set myTimeStamp = @myRevTimestamp, LastUpdate=getdate(), LastExecuted = getdate(),RecordCount=@RecCount where TableID=11
update NavSync set LastExecuted = getdate() where TableID=11
Thank-you for your help!