dan_was_here_andrew_beadle

SELECT
    FACT_INVENTORY.BUSINESS_UNIT      AS site
,   FACT_INVENTORY.ITEMCODE           AS item_code
,   ''                                AS supplier_spec_num
,   dimitem.ITEMSHORTDESC             AS item_short_description
,   FACT_INVENTORY.DIMA               AS width
,   SUM(FACT_INVENTORY.INVENTORYQTY)  AS footage
FROM      dbo.FACT_INVENTORY
LEFT JOIN dbo.DIMITEM ON 'y' = fact_inventory.CURRFLAG
                     AND fact_inventory.BUSINESS_UNIT = DIMITEM.BUSINESS_UNIT
                     AND fact_inventory.ITEMCODE      = DIMITEM.ITEMCODE
WHERE 1=1
AND 'y' = fact_inventory.CURRFLAG
GROUP BY
    FACT_INVENTORY.BUSINESS_UNIT
,   FACT_INVENTORY.ITEMCODE
,   dimitem.ITEMSHORTDESC
,   FACT_INVENTORY.DIMA