Good morning, i've to build a SQL SELECT in order to merge two datas coming from different sources:
- a field coming from a file .xls
- another field coming from a ODBC
This will add the calculation of the margin range in the load script in order to use it in reports.
I started with a:
LEFT JOIN
LOAD
//of xls data to ODBC
//Billing Key is the common key
SELECT
,CASE
WHEN ROUND((a.Sales-b.Costs)/a.Sales,2) < -1 THEN 'less than -100%'
WHEN ROUND((a.Sales-b.Costs)/a.Sales,2) BETWEEN -.99 AND -.5 THEN 'FROM -100% and -50%'
.....
ELSE 'ND'
END AS [range]
FROM (SELECT Billing Key,SUM(Costs) AS (Costs) FROM Days GROUP BY Billing Key) b
ON a.Billing Key=b.Billing Key;
But i don't understand what's going wrong, perhaps this sintax isn't correct? Thank you for help