Viewing 5 posts - 1 through 5 (of 5 total)
Ok, I'm feeling a bit perplexed now. While fiddling around with this, I decided to create an actual table which contained my set, therefore eliminating the insert in my batch...
July 11, 2007 at 12:13 pm
declare @a int, @b int select @a = 3, @b = 5 ;with gcd (a, b) as (select @a, @b union all select b, a % b from gcd where...
May 29, 2007 at 9:19 am
declare @a int, @b int select @a = 3, @b = 5 ;with gcd (a, b) as ( select @a, @b union all select b, a % b from gcd where b...
May 29, 2007 at 9:10 am
with
r3 (remainder, format) as (select 3, 'Bizz'),
r5 (remainder, format) as (select 5, 'Buzz'),
r15 (remainder, format) as (select 15, 'BizzBuzz'),
...
May 29, 2007 at 8:16 am
Viewing 5 posts - 1 through 5 (of 5 total)