Thanks!

not sure what your getting at. I guess because it runs recursively and relys on previous result set to generate next which is a more programmatical construct?

Would you advocate...

because they cannot be run in parallel guess?

--Now scalable, set based and added a fizzbuzz!

DECLARE @threshold int = 100

;WITH numbers ( seqnum )

AS (...

window function version

SELECT TOP 100 --*

--,

CASE WHEN ROW_NUMBER() OVER (ORDER by object_id) % 3 = 0 THEN 'FIZZ'

WHEN ROW_NUMBER() OVER (ORDER by object_id) % 5 = 0 THEN 'BUZZ'

ELSE...