Get a list based on start date and end date by giving monthid as parameter

[ssreevidya.m]

Hai ,
I have 2 tables

1. Transport_Details having columns
user_id
FareStageId
StartDate
EndDate

and
2. Route_Fee having columns
FareStageId
monthId
fees

I need to get a monthwise list by passing monthid.
But my problem is that , if start date and enddate of a user are 02-08-2011 and
20-02-2012 and I need to get the list of 4th month , this user also listed.

Query I used is:

select Transport_Details.User_Id, Route_Fee.Fee, from Transport_Details join Route_Fee
on Transport_Details.Bus_Route_Fare_Stage_Id=Route_Fee.Bus_Route_Fare_Stage_Id where Route_Fee.Month=4

Can i get the list of those users , the monthid between startdate and enddate.

Thanks in advance.

[urtrivedi]

I have replied your previous thread, you may check it whether it is helping u or not.

http://www.daniweb.com/web-development/databases/ms-sql/threads/389707/1684223#post1684223