Viewing 4 posts - 1 through 4 (of 4 total)
Awesome. Jason had left out one ISNULL and that zero at the end. That did it. Perfect. Thank you Jason and Sean for your help. I appreciate it very much
July 10, 2012 at 2:02 pm
Ok so in this case, there were zero payments made for the first query. The query does not find any results, so it says the result is NULL.
First Query
Select SUM(ISNULL(Amount,...
July 10, 2012 at 1:50 pm
I tried and I really thought that was going to work but it didn't. Is this set up right? It still says my total = NULL. I'll give you...
July 9, 2012 at 3:35 pm
So like this? Sorry I have not used SET Command before. I'm pretty new to SQL. This didnt work in this format, but I think it is wrong the way...
July 9, 2012 at 3:26 pm
Viewing 4 posts - 1 through 4 (of 4 total)