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);
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.
I’d like to grow my readership. If you enjoyed this blog post, please share it with your friends!
