SELECT x.Name,
CASE
WHEN x.XlName > '' THEN x.XlName
ELSE x.Name
END AS E_COL,
x.[Order],
x.Width,
c.Column_Name,
c.Data_Type
FROM dbo.XLS_XLS AS x
LEFT JOIN INFORMATION_SCHEMA.COLUMNS AS c ON c.Column_Name = x.Name
AND c.Table_Name = 'STUDENT'
WHERE x.[Status] = 1
AND x.[Order] <> 0
ORDER BY x.[Order]
N 56°04'39.26"
E 12°55'05.63"