| http://www.w3.org/ns/prov#value | - Numbers (Number, Mod3, Mod5, Mod15) as (select cast(number as varchar(10)), number%3, number%5, number%15 from #Numbers)select case when Mod15 = 0 then 'BizzBuzz' when Mod5 = 0 then 'Buzz' when Mod3 = 0 then 'Bizz' else Numberendfrom Numbers;To make this work in SQL 2000, you would have to use something other than sys.all_objects, but anything that will generate the right number of rows is good enou
|
