Sorry.....

For that encounter Index_AMI should get "0" and Is_Readmission should get "1"

Hi,

I have attached Current output and Expected Output screen shots in below. please check this and help me to resolve.

Table Structure and Sample Data:

Create Table #Patient_Readmission

(Patent_Code int,

Encounter_Code int,

Admit_Date_Time datetime,

Discharge_Date_Time datetime,

Is_AMI_Readmission...