Still didn't get it. If same parameters, then same data has to get returned. That's what my point is.

Its the same parameters. still ssms was not showing up this errors.

Thanks Luis. One more clarification, why SSMS is not showing that error and why only Azure portal Query editor was able to detect it ?

Thanks a lot Luis. I ll make that change and try and keep you posted. Tmr I will try this out.

What I understand is, you have avoided...

Thanks John it worked fine. it was throwing some constraint errors. I can fix it.

Deadlocks are because they can run Publish and Sync simultaneously and same tables gets referenced using Foreign keys and update operations. Thats why seeing deadlocks.

Thanks Steve for the suggestions.

Extremely sorry, my bad. there were some typos. Updated my original post.

Hi Rick/Lynn,

Forgot to ask.

Do I need to SET TRANSACTION ISOLATION LEVEL SERIALIZABLE inside both the processes (i.e. both code pieces stored proc and...

Thanks Rick.

Any thoughts on disabling lock escalation or it doesn't really matter/applicable in this scenario??

Rick, many thanks for the response. Just for my understanding sake, Looking at the xml deadlock graph data,
Insert is happening on Questionare.FieldValues (spid 79) and delete is happening on...