Thank you I will take a look and keep posted here if it solves my issue. Thank you!

The Answer is that is how our vendor asked us to send our weekly files going forward. I think they are using SAS programming and their system accepts the files...

Thank you Phil for this idea, i will test and let you know if this is working.

• This reply was modified 2 years, 2 months ago by  dhanekulakalyan.

Thanks for your reply, let me verify this.

Thank you for your reply and help, this is working but I cannot understand why we are multiplying with 2* to the row number for e and s columns and...

Insert INto #test1 values(1,333,'10/17/2019','10/29/2019',0,0,0,0,0)

Insert INto #test1 values(2,333,'10/29/2019','11/11/2019',1, 1,1,1,1)

yes this is what I mean '10/29/2019' for enddate for one admission and startdate for another admission, this is pulling into my, I...

Hello, As mentioned above I tested for few other members and it is working as expected. First of all I would like to thank you very much for your help....

Solution posted absolutely works for the test data I provided, I will be testing with other members with actual data and will keep you posted may be in a day...

Hello, please see my answers below.

Your Question -- What I mean is hypothetically could we have 2 or more new rows with MemberID 111 happen in 2020 and thus outside...

Hello,  Yes, I think what you said is correct, I want readmit count based on the quarter of the parent. (I think that's what I tried to explain in my...

Hello, first of all thank you for responding on my question pretty fastly. Appreciated it!!!

This is working partially okay but for 180dayreadmits this is not working as expected. for any...

I am using sql server 2014, I am getting below error.

'eomonth' is not a recognized built-in function name.

Hi Luis,
I think I understand this but the way you used LAG function for finding ThreeOrMoreEvents was good thought. Can you also understand me how did you used this...

It is working for me, Thank you for keeping this reply.