INSERT INTO dbo.MER_Sales
(
ORDER_ID,
MAT_YEAR,
Delivery_Address,
Rep_SalesStats,
REP_ID,
MERCHANT,
Payer_TradeAddress,
PAYER,
PRODUCT,
ITEM_QUANTITY,
ITEM_VALUE,
Period,
Division_Reference
)
SELECT 
'', 
dbo.RMS_SALESSTATS.SOS_YEAR,
dbo.Delivery_Address.Delivery_Address_ID,
dbo.RMS_SALESSTATS.SOS_REP,
dbo.MER_REPS.REP_ID,
'',
CustAddress.ADD_CODE,
dbo.MER_Payer.Payer_ID,
dbo.MER_Product.Product_ID,
CAST(dbo.RMS_SALESSTATS.SOS_QUANTITY_7 AS DECIMAL (18,4)),
CAST(dbo.RMS_SALESSTATS.SOS_VALUE_7 AS DECIMAL (18,2)),
'7', 
'1' 
FROM 
(((((((dbo.RMS_SALESSTATS JOIN dbo.RMS_ADDRESS AS CustAddress ON 
CustAddress.ADD_CODE = dbo.RMS_SALESSTATS.SOS_CUSTOMER AND
CustAddress.ADD_COMPANY = dbo.RMS_SALESSTATS.SOS_CO) 
JOIN dbo.RMS_ADDRESS AS LocAddress ON
LocAddress.ADD_CODE = dbo.RMS_SALESSTATS.SOS_LOCATION AND
LocAddress.ADD_COMPANY = dbo.RMS_SALESSTATS.SOS_CO)
JOIN dbo.RMS_TRADERS ON
dbo.RMS_SALESSTATS.SOS_CUSTOMER = dbo.RMS_TRADERS.TRD_CODE AND
dbo.RMS_SALESSTATS.SOS_CO = dbo.RMS_TRADERS.TRD_COMPANY)
JOIN dbo.RMS_ADDRESS As TradeAddress ON
dbo.RMS_TRADERS.TRD_COMPANY = TradeAddress.ADD_COMPANY AND
dbo.RMS_TRADERS.TRD_INVOICE_REF = TradeAddress.ADD_CODE)
JOIN dbo.Delivery_Address ON
dbo.RMS_SALESSTATS.SOS_CUSTOMER = dbo.Delivery_Address.ADD_CODE)
LEFT JOIN dbo.MER_REPS ON
dbo.RMS_SALESSTATS.SOS_REP = dbo.MER_REPS.ADD_CODE)
LEFT JOIN dbo.MER_PAYER ON
dbo.MER_Payer.Customer_Reference = dbo.RMS_SALESSTATS.SOS_CUSTOMER)
LEFT JOIN dbo.MER_Product ON
dbo.MER_Product.Product_Reference = dbo.RMS_SALESSTATS.SOS_PRODUCT 
WHERE 
dbo.RMS_SALESSTATS.SOS_RECTYPE = 'B' AND
dbo.RMS_SALESSTATS.SOS_CO = 'B' AND
CAST(dbo.RMS_SALESSTATS.SOS_QUANTITY_7 AS DECIMAL (18,4)) > 0.0000 AND 
CAST(dbo.RMS_SALESSTATS.SOS_VALUE_7 AS DECIMAL (18,2)) > 0.00 AND
CustAddress.ADD_TYPE = 'C' AND
dbo.RMS_TRADERS.TRD_TYPE = 'C' AND
TradeAddress.ADD_TYPE = 'C' AND
LocAddress.ADD_TYPE = 'L' AND
SUBSTRING(LocAddress.ADD_Message, 9, 2) = 'KA' AND
dbo.Delivery_Address.Division_Reference = '1' AND
dbo.MER_REPS.Division_Reference = '1' AND
dbo.MER_Payer.Division_Reference = '1' AND
dbo.MER_Product.Division_Reference = '1' 
GROUP BY dbo.RMS_SALESSTATS.SOS_YEAR,
dbo.Delivery_Address.Delivery_Address_ID,
dbo.RMS_SALESSTATS.SOS_REP,
dbo.MER_REPS.REP_ID,
CustAddress.ADD_CODE,
dbo.MER_Payer.Payer_ID,
dbo.MER_Product.Product_ID,
dbo.RMS_SALESSTATS.SOS_QUANTITY_7,
dbo.RMS_SALESSTATS.SOS_VALUE_7