Pawan Kumar Khowal (6/13/2016)

---

SELECT ROW_NUMBER() OVER (ORDER BY NAME) Id , Name FROM

(

SELECT Id,Name FROM [dbo].[Table1]

UNION ALL

SELECT Id,Name FROM [dbo].[Table2]

)r

Pawan Khowal

_________________________________________________________________________________________________________

https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/