Thank you, I was just adding more information to my question.

Thanks again!

Thank you for the reply!

Apologies, I made an error in the test data. I updated the test data now.

groupingnum 1 has two members (A123, A456). A123 has a Cancelled transtype,...

• This reply was modified 1 year ago by  ssc_san. Reason: formatting

Thank you for the reply.

I was expecting groupnum = 1 and 5 as those two groups have only 1 active memberid.

 

Thank you!

 

Thank you Scott! This is very helpful.

Thank you for your time Scott! I will try this.

Thank you ratbak! Is there anyway to just get the records that are different. I tries Count window function but it is removing some of the records.

Thank you for your...

Thank you jschmidt! I combined Sergiy & Ken's solution to get what I needed. You query laid it out in detail.

Thank you all!

Thank you! You all helped me to learn something new and with the solution.

Yes, if there are no gaps I have to show the initial eff date and most recent term date with product subscribed when subscription termed.

Thank you!

Thank you! Drew & Jeffrey.

Yes, to some high date as '12/31/2099'

 

Thank you for your help!

Hi,

Thanks for the reply.

I am trying to compare the data from two tables and display any difference in coverage in #app2 table. There is gap in coverage for CustID 798...

Thank you Joe for your time and solution! there is a little change in the requirement and it added more complexity.

create table #pick
(
Member_id INT,

sgmunson (11/2/2016)

---

How about this one, which specifies the exact conditions of the original post:

CREATE TABLE #tst (

Id int,

Unit int,

Selct varchar(25),

Rtm varchar(10),

Agnt varchar(10)

);

INSERT INTO #tst (Id, Unit, Selct, Rtm, Agnt)

SELECT 1001,...

ScottPletcher (11/1/2016)

---

Hard to determine exactly what you want, but my best guess is something like below; adjust the case conditions to be specifically what you need them to be:

select *

from...