tao so la ma

Question

SELECT  dbo.ToRoman(ROW_NUMBER() OVER(ORDER BY mact ASC)) AS stt2,* FROM tbl_chitiet WHERE manl ='-' AND mamh='0708' AND stt NOT LIKE '%.%'
UNION
SELECT  CONVERT(VARCHAR,ROW_NUMBER() OVER(ORDER BY mact ASC)) AS stt2,* FROM tbl_chitiet WHERE manl <>'-' AND mamh='0708' AND stt NOT LIKE '%.%'
UNION

SELECT stt AS stt2,* FROM tbl_chitiet WHERE mamh='0708' AND stt LIKE '%.%'

ORDER BY sx