Sorry it didn't. My from_date and to_date are stored as integers.

Are While loops considered bad development? I have a 100 combinations of facility/months to go through.

It seems like I am not communicating my issue well.

I wrote a sp with a while loop in it and I am getting what I want.

Thanks

SJ

My expected results are the total number of Members at the end of every month - not members who were added during the month.

I only added data for 2 months. If I could get the results like I want for the 2 months I will be happy.

My issue is I don't know...

This is some sample data

drop table #sample_data

create table #sample_data

(

memberid varchar(10),

facility varchar(2),

from_date int,

to_date int

)

insert into #sample_data

(memberid, facility, from_date, to_date)

select '10001', '01', 20100115, 20101231 union all

select '10002', '01', 20100115, 20101231 union all

select...