// SQL เลข Control Number ล่าสุด

fetchcontrolno.sql

SELECT       SUBSTRING(MAX(dbo.tb_opr_Control.Control_No), CHARINDEX('-', MAX(dbo.tb_opr_Control.Control_No)) + 1, 4) AS User_EmpCode, RIGHT(MAX(dbo.tb_opr_Control.Control_No), 4) AS MaxRunning, 
                         dbo.tb_opr_Control.Control_Creator, dbo.tb_auth_User.User_ID
FROM            dbo.tb_opr_Control LEFT OUTER JOIN
                         dbo.tb_auth_User ON dbo.tb_opr_Control.Control_Creator = dbo.tb_auth_User.User_Username
GROUP BY dbo.tb_opr_Control.Control_Creator, dbo.tb_auth_User.User_ID