macromedia.coldfusion.cfml_general_discussion
[Top] [All Lists]

Re: Query Help

Subject: Re: Query Help
From: "cf_dev2"
Date: Wed, 8 Aug 2007 19:54:21 +0000 UTC
Newsgroups: macromedia.coldfusion.cfml_general_discussion
"END" is part of the CASE statement so it must be inside the SUM parenthesis 

                 SUM (   CASE WHEN blah THEN x ELSE y [b]END[/b] ) AS Jan


<Prev in Thread] Current Thread [Next in Thread>