b.-- create temp tableCreate Table #t (a int identity(1,1), b int default 0);go-- populate itinsert #t (b) values (default);go 40-- build cteWith CTE as ( SELECT a, b, newid() c FROM #t)-- union would filter distinct, so we should-- have 10 rows if the cte is the same every time-- in fact it returns 20 because CTE is re-evaaluated-- with each referenceSELECT top 10 a, c FROM CTEUNIONSELECT top 10 a, c FROM CTEdrop table #t