SELECT DISTINCT SED.MCSED_SED_Short_Description, SCH.Doc_SNo,
ord = CASE SED.MCSED_SED_Short_Description WHEN 'VD' THEN 1 ELSE 2 END,
SCH.Doc_No
FROM @Schedule_Status SCH , DMS_M_Company_Schedule_Element_Details SED
WHERE SED.MCSED_SED_Code =123
ORDER BY CASE SED.MCSED_SED_Short_Description WHEN 'VD' THEN 1 ELSE 2 END,
SCH.Doc_SNo, SCH.Doc_No