declare @max INT = 1000,@s varchar(max) ='' ;WITH Tally_Numbers(n) AS ( SELECT 2 UNION ALL SELECT n+1 FROM Tally_Numbers WHERE n <= @max ) ,cte1 as( select Tally1.n from Tally_Numbers Tally1 where not exists (select 1 from Tally_Numbers Tally2 where Tally2.n < Tally1.n AND Tally1.n % Tally2.n = 0) ) SELECT STUFF(( SELECT '&' + CAST(r.N AS VARCHAR(10)) AS "text()" FROM cte1 r ORDER BY r.N FOR XML PATH(''),TYPE).value('./text()[1]','VARCHAR(8000)'),1,1,'') OPTION (MAXRECURSION 0);I’d like to grow my readership. If you enjoyed this blog post, please share it with your friends!
While on HackerRank puzzles, I came through a question to find out prime numbers in SQL Server.
Here is my try as below. You may try your own and share the code in the comment.