SSChampion you are right, I changed T8 to "T" and I got the query to work

Hmm, I guess I will do that then but Is there a way I can find all the values in my where clause that show me which table they are...

Yes, my original plan was basically use an update statement of each table but there about 30 tables it is listed in. So I wanted to find out was there...

Thank you Sean for you help. Really appreciate it

Maby my select statement might help. So I am trying to see how many contracts are purchased for every month. And if its Feburary than up to the 28th is...

Like for example lets say I Have 14 people who made payments to their account, I want to know in those 30 days of September how many people payed their...

Okay lets say the user inputs @begin_date 04/02/2014 and @End_Date 06/30/2014. That user is only suppose to see

April and May's contracts.

The problem is it shows ALL the months...

Hey David, for the YTD, which totals the months funded contracts is there a different type of expression for it? or do I need to filter it?

Thank you all of you for the help. My report is finally done. Much appreciated to all that helped out on this thread! Thanks again!

Thanks corbet, I showed the client that way as well. The thing that sucks is they don't want it like that because the format is not the way they want...

Thanks SQLRUNNER, I know I showed them the report using a Matrix and it worked great but unfortunately they want it as a table. So I will take yours and...

That would have worked but the way my query is set up is, The user should only see the passed months from the present month within the year 2014 ONLY....

Yes, it works with a matrix but unfortunately the client I'm working for wants it as a table that's the problem. I was thinking about Using a PIVOT function but...

I am using SQL server 2008R2

So I have gone and input the date, But on the AND > on the codec is an incorrect syntax error.

WHERE '01/29/2014' >= dateadd(yy, datediff(yy, 0, GETDATE()), 0) --Beginning...