Thanks for the insight Grant. We have two new prod servers in one location and two DR servers in another location. We have rto of 2 hours and rpo is...

Thanks Jeff. Very helpful and interesting.

Thom, both urs and Luis' query gave me a fair idea of how I should start. However the table gets populated on daily basis and the report is needed on...

Thanks to both of you guys. However there is no limited number of Org_ids. It can vary and change from time to time.
In between, I replied many hours back...

Apologies for late response. So here is the complete picture:
Every user is mapped with one or more unit ids. Every month when our batch is processed, all entries get...

Hey Thom, these are dates only and no VARCHAR. I gave few records to show they type of data. All date related columns are in datetime data types only.

Thanks Sue. However I was looking for something to see if there can be any code breaks while going from SQL 2008 r2 to 2014. Any code which will need...