CASE WHEN tbl_CCMonitorSheetAnswer.Answer = 'False' THEN Round(tbl_CCMonitorFormQuestion.Points - tbl_CCMonitorFormQuestion.Points, 0) 
WHEN tbl_CCMonitorSheetAnswer.Answer IS NULL THEN NULL ELSE Round(tbl_CCMonitorFormQuestion.Points, 0) END AS [Achieved Points], 
CASE WHEN tbl_CCMonitorSheetAnswer.Answer

CASE WHEN tbl_CCMonitorSheetAnswer.Answer = 'False' THEN (tbl_CCMonitorFormQuestion.Points - tbl_CCMonitorFormQuestion.Points) 
                      WHEN tbl_CCMonitorSheetAnswer.Answer IS NULL THEN NULL ELSE tbl_CCMonitorFormQuestion.Points

select ReceivedDate,orderstatus WHERE RecieveDate BETWEEN ''20071101' AND '20071231'
        ,count(case when dcoc = '88' then 1 end) as cnt88
        ,sum(case when dcoc = '88' then ordertotal end) as sls88
from orders
group by ReceivedDate,orderstatus

@echo off
REM - File: iisrestarter.bat
REM - Description: checks for the existence of iisrestart.txt then restarts iis and deletes the txt file

IF EXIST restartiis.txt (GOTO :true) ELSE GOTO :false

:true
echo Restarting IIS and FTP.....
echo ===================================================
net stop "World