SELECT * INTO Inventory_maxtemp
FROM
(SELECT
h.qlw,MAX(h.cInvCode) zdz
FROM
(SELECT m.cInvCode ,
m.cInvName,
n.qlw
FROM Inventory m
JOIN ( SELECT( LEFT(b.cInvCode, 4)+ SUBSTRING(b.cInvCode,6, 4) ) AS qlw,b.cInvCode
FROM dbo.Inventory b) n
ON m.cInvCode=n.cInvCode)h
GROUP BY h.qlw) p