How to Generate Sequence without using Ranking functions in SQL Server?
Ans: Spose you have a temp table with only one column 'A' as above, Now you can use following query to generate sequence ...
http://www.interviewquestionspdf.com/2017/06/how-to-generate-sequence-without-using.html
Spose you have a temp table with only one column 'A' as above, Now you can use following query to generate sequence
SELECT COUNT(*) OVER(ORDER BY A, CONCAT(A,NEWID())) RN, A FROM #temp1
