I have gone thru your problem and found that it can be done in the following way where we are traversing the source table twice.

Will think about another solution which...

Hi

You can write query like this:

suppose say you are passing two parameters name @StartDate and @EndDate and you column name in table is TransDate

TransDate BETWEEN ISNULL(@StartDate, TransDate) AND ISNULL(@EndDate, TransDate)