Update and insert records filter based on conditions in sql server

[bitsmed]

Same school assignment as this?
Especially this section looks identical:

@harinadhuhari

[if found single qualified records on patientstatus for one single patient record,then record consider as update in the filter and guid taken from patientstatus[if found multiple qualified records on patientstatus for one single patient record,then select min of patientstatus record and then consdier records is update and guid comes from patientstatus[if found multiple qualified records on patient for one single patientstatus record,then select min of patient record and consider as update record and guid taken from patientstatus table.

[if found multiple qualified records on patient for multiple qualified patientstatus records,then select min of patient and target record and guid taken from patientstatus table.