---

SELECT 
    skln.SklN_Cd AS Article,
    skln.SklN_Nm AS Name,
    skln.SklN_NmAlt AS Tooling,
    CAST(skln.SklN_Rcd AS varchar(50)) AS ProductKey,
    CAST(SUM(CASE WHEN skldcs.SklDcs_Mov = 1 THEN skldcs.SklDcs_QtOsn ELSE -skldcs.SklDcs_QtOsn END) AS varchar(50)) AS MPK,
    sklstor.SklStor_Nm AS Rack,
    '' AS ProductionOrder,
    ei.EI_ShNm AS Country
FROM SKLDCS skldcs
INNER JOIN SKLKRT sklkrt ON skldcs.SklDcs_Krt = sklkrt.SklKrt_Rcd
INNER JOIN SKLSTOR sklstor ON sklkrt.SklKrt_Stor = sklstor.SklStor_Rcd
INNER JOIN SKLN skln ON sklkrt.SklKrt_RcdNom = skln.SklN_Rcd
INNER JOIN EI ei ON skln.SklN_EiOsn = ei.EI_Rcd
WHERE skldcs.SklDcs_Dat <= GETDATE()
   OR YEAR(skldcs.SklDcs_Dat) < 1900
GROUP BY 
    skln.SklN_Cd, 
    skln.SklN_Nm, 
    skln.SklN_NmAlt, 
    skln.SklN_Rcd,
    sklstor.SklStor_Nm,
    ei.EI_ShNm
HAVING SUM(CASE WHEN skldcs.SklDcs_Mov = 1 THEN skldcs.SklDcs_QtOsn ELSE -skldcs.SklDcs_QtOsn END) > 0
ORDER BY skln.SklN_Cd, skln.SklN_NmAlt, skln.SklN_Nm, ei.EI_ShNm