Next time please ensure that you provide small sample scripts to create data and populate. Those who want to help

you will use these scripts to recreate the issue...

Moving on to...

haha ... i am wondering the same thing too .... mine also does not require a distinct and neither does yours (Lynn's)..

So where did the grasshopper add 'Distinct' ??

:hehe:

This final one does exactly what you need..... though I am unsure why you want this in place of the one i sent before...

select day_date, cl2.client_id, cl2.schedule_date from (Select distinct...

I am sorry ...i did not look too deeply...

here is the updated one...

select day_date, cl.client_id, cl2.schedule_date from (Select distinct client_id from #client) cl

cross join #date_dim dd

left join #client cl2

on cl2.schedule_date=dd.day_date

and...

Try this....

select day_date, cl.client_id, cl2.schedule_date from (Select distinct client_id from #client) cl

cross join #date_dim dd

left join #client cl2

on cl2.schedule_date=dd.day_date

This is the closest I got to...

Yeah, I am doing that too .... but remember that I need to sift through questions and find the kind that I am

looking for. For eg: questions like how to...

Thanks fro all the responses guys ... I will definitely check out these books.