SELECT SUM(IIF(division = 'Northern',1,0)) AS NODQTY, SUM(IIF(division = 'Northern',tonnage,0)) AS NODTonnage,; SUM(IIF(division = 'New England',1,0)) AS NEDQTY, SUM(IIF(division = 'New England',tonnage,0)) AS NEDTonnage,; SUM(IIF(division = 'Mid-Atlantic',1,0)) AS MADQTY, SUM(IIF(division = 'Mid-Atlantic',tonnage,0)) AS MADTonnage,; SUM(IIF(division = 'Mid-South',1,0)) AS MSDQTY, SUM(IIF(division = 'Mid-South',tonnage,0)) AS MSDTonnage,; SUM(IIF(division = 'Southern',1,0)) AS SODQTY, SUM(IIF(division = 'Southern',tonnage,0)) AS SODTonnage,; SUM(IIF(division = 'Mid-West',1,0)) AS MWDQTY, SUM(IIF(division = 'Mid-West',tonnage,0)) AS MWDTonnage,; SUM(IIF(division = 'North West',1,0)) AS NWDQTY, SUM(IIF(division = 'North West',tonnage,0)) AS NWDTonnage ; FROM curProjects ; INTO CURSOR curTemp WHERE !DELETED() GROUP BY divisionThis produces a cursor with something similar to the following:
Nodqty Nodtonnage Nedqty Nedtonnage Madqty Madtonnage ... 0 0 0 0 68 25712 0 0 20 52276 0 0 143 540593 0 0 0 0Is there a way to construct the sql select statement so that I get one line like the following:
Nodqty Nodtonnage Nedqty Nedtonnage Madqty Madtonnage ... 143 540593 20 52276 68 25712Thanks in advance,