Using CASE statement in SQR's Where Clause
jhansen (guest) 02 Aug 2011 16:38
When running this sql statement in SQL Server's query window, I get 10 EMPLID's. However, when using the identical query in SQR, I am getting zero results. How do I use a CASE statement in the SQR's Where Clause.
begin-Procedure Array-Populate-Non9110 let #i = 0 begin-SELECT DISTINCT A.EMPLID DISPLAY &A.EMPLID FROM PS_PROJ_RESOURCE A, PS_PROJ_AN_GRP_MAP B WHERE B.SETID = A.BUSINESS_UNIT AND B.ANALYSIS_TYPE = A.ANALYSIS_TYPE AND A.BUSINESS_UNIT = 'PROJA' AND A.FUND_CODE = '436' AND (CASE WHEN A.ANALYSIS_TYPE ='ACT' AND A.JOURNAL_DATE IS NOT NULL THEN A.JOURNAL_DATE ELSE A.ACCOUNTING_DT END) BETWEEN $FROM_DATE AND $THRU_DATE AND B.ANALYSIS_GROUP = 'ACT' AND A.CLASS_FLD <> '9110' ORDER BY A.EMPLID DESC End-SELECT end-procedure
