I have to databases that I connected together using a UNION. That was not a problem. I now need to create a running total using all of the data within the UNION. I can make a running total that does one table or the other, the problem is when I try to create the running total on the UNION. The result is nothing close to correct running total.

Is there an issue calculating a running total over a UNION?? Is there another way to do...

That didn't work. It gave me one column with 1 thru 6 multiple times and a second column of just 2006.

This problem has to do with the statement in the THEN part of the CASE statement. SQL doesn't like the = sign. If there is a way to do it without the = sign I think that would work, but don't know how....

I am trying to put a case statement into my Having Clause or Where Clause. Both come up with the same error "Error near '='" in the THEN statement. I'm not sure why this is not working. The idea of this statement is to look at the date and if it is the first of the month it will return last months data, if not it gives me this months data.
If someone could give me and idea as to why this doesn't work or another solution that...