How does this look...simple

Use MYDb;

GO

SELECT ROW_NUMBER() OVER(ORDER BY X) AS Row,

A, B, C

FROM Z;