SELECT t.[Admissions_key],t.MRN,t.hosp_code,t.adm_datetime,t.sep_datetime,t.Sequence,

ROW_NUMBER() OVER (PARTITION BY t.MRN,t.hosp_code,t1.[Admissions_key] ORDER BY t.[Admissions_key]) AS newro

FROM dbo.tempnewborn t

OUTER APPLY(SELECT TOP 1 [Admissions_key]

FROM...

go to next page half work is done i think so now its my time is to sleep. can u please have a look and further dig it out.

Yes I think you are just talking about 1 group, if we take it as a whole than we should have some thing like this

I excluding admissions, MRN, HOSP_code,...

I think here issue is that how I can compare 1 record with another and do any test as I also need to compare there dates in future.

I am...

Problem Definition:

I have list of records, having columns Admissions_key,MRN, hosp_code, adm_datetime, sep_datetime,Sequence and many other columns

There would be multiple records for same MRN and Hospital code. With difference in...

Thank you for your replies, I am sending once again the correct data, I would appreciate if you can further help. I think I was unable to explain that I...