This seems very similar to a previous question of yours.  What have you already tried? And where are you getting stuck?

Drew

A recent thread reminded me of a t-shirt that a friend of mine has:

It took me less than a minute to open up SSRS, go to the Expression Builder, and look under "Common Functions" to find the answer.  This isn't rocket science.

There are several issues with this: 
1)  You are returning the MAX() of a field from the main query.  Since the subquery is evaluated for each row in the...

Please don't start multiple threads on the same topic. It fragments the discussion.

Please post responses to How to Execute SQL Agent Job Using Wildcard.

Drew

If I understand you correctly, you don't really want to do this.  You should only have one date field in your table and you should use LAG/LEAD to get the...

In this case, the equal sign is being used as an assignment operator, not a comparison operator.  In other words, you're assigning the value to the parameter, not checking to...