blhickman · October 7, 2015 20:39
diff --git a/gistfile1.txt b/gistfile1.txt
 SELECT DISTINCT SLSM_NUM, SLSM_DESC, SalesGroup, 0 AS PYTDExt_GP, 0 AS Ext_GP, 0 AS GPGrowth, NULL AS GPTarget
 FROM            SALESMAN AS SALESMAN_3
 WHERE        (SLSM_NUM IN ('103', '104', '105', '108', '110', '111', '113', '114', '121', '125', '136', '123', '124', '151', '176', '177')) AND (SLSM_NUM NOT IN
                             (SELECT DISTINCT OH3Y_2.SLSM_NUM
                               FROM            OH3Y AS OH3Y_2 INNER JOIN
                                                         Time AS Time_2 ON OH3Y_2.INV_DATE = Time_2.PK_Date
                               WHERE        (OH3Y_2.SLSM_NUM IN ('103', '104', '105', '108', '110', '111', '113', '114', '121', '125', '136', '123', '124', '151', '176', '177')) AND 
                                                         (Time_2.FiscalYear = 'FY2016')))
	SELECT DISTINCT SLSM_NUM, SLSM_DESC, SalesGroup, 0 AS PYTDExt_GP, 0 AS Ext_GP, 0 AS GPGrowth, NULL AS GPTarget
	FROM SALESMAN AS SALESMAN_3
	WHERE (SLSM_NUM IN ('103', '104', '105', '108', '110', '111', '113', '114', '121', '125', '136', '123', '124', '151', '176', '177')) AND (SLSM_NUM NOT IN
	(SELECT DISTINCT OH3Y_2.SLSM_NUM
	FROM OH3Y AS OH3Y_2 INNER JOIN
	Time AS Time_2 ON OH3Y_2.INV_DATE = Time_2.PK_Date
	WHERE (OH3Y_2.SLSM_NUM IN ('103', '104', '105', '108', '110', '111', '113', '114', '121', '125', '136', '123', '124', '151', '176', '177')) AND
	(Time_2.FiscalYear = 'FY2016')))