I am adding table and insert scipts to a sample table for ease of understanding. thanks

create table #tabA

(

memid varchar(10),

monthStartDate datetime

)

--drop table #tabA

Insert into #tabA (memid,monthStartDate)

values(123,'2014-01-01'),

(123,'2014-03-01'),

(123,'2014-04-01'),

(123,'2014-05-01'),

(123,'2014-06-01'),

(123,'2014-07-01'),

(123,'2014-08-01'),

(123,'2014-09-01'),

(123,'2014-10-01'),

(123,'2014-11-01'),

(123,'2014-12-01'),

(222, '2014-01-01'),

(222 , '2014-02-01'),

(222, '2014-03-01'),

(222...

Any thoughts on this ?

Hi Gail,

I just gave one example 141928888M here thats the claimid field there are 3.7 claimids eg: 22141213888M or 33333356A123 something like that.

Thanks,

Kalyan

Hi Steve,

Thanks for your reply . Please see my answers below.

1) This is a database for a third-party product where we cant make changes to the Database table structure. I.e...