Home Forums Programming General Reverse string without built in functions RE: Reverse string without built in functions

  • Michael Valentine Jones (4/17/2009)


    OK, as long as we are doing useless SQL, I want to add numbers together without using any Arithmetic, Logical, Assignment, String, Bitwise, or Unary Operators or any Mathematical or Aggregate Functions.

    create table #Sums (

    Num1 int not null,

    Num2 int not null,

    Sum12 int);

    insert into #Sums (Num1, Num2, Sum12)

    select 0, 0, 0 union all

    select 1, 0, 1 union all

    select 2, 0, 2 union all

    select 3, 0, 3 union all

    select 4, 0, 4 union all

    select 5, 0, 5 union all

    select 6, 0, 6 union all

    select 7, 0, 7 union all

    select 8, 0, 8 union all

    select 9, 0, 9 union all

    select 0, 1, 1 union all

    select 1, 1, 2 union all

    select 2, 1, 3 union all

    select 3, 1, 4 union all

    select 4, 1, 5 union all

    select 5, 1, 6 union all

    select 6, 1, 7 union all

    select 7, 1, 8 union all

    select 8, 1, 9 union all

    select 9, 1, 10 union all

    select 0, 2, 2 union all

    select 1, 2, 3 union all

    select 2, 2, 4 union all

    select 3, 2, 5 union all

    select 4, 2, 6 union all

    select 5, 2, 7 union all

    select 6, 2, 8 union all

    select 7, 2, 9 union all

    select 8, 2, 10 union all

    select 9, 2, 11 union all

    select 0, 3, 3 union all

    select 1, 3, 4 union all

    select 2, 3, 5 union all

    select 3, 3, 6 union all

    select 4, 3, 7 union all

    select 5, 3, 8 union all

    select 6, 3, 9 union all

    select 7, 3, 10 union all

    select 8, 3, 11 union all

    select 9, 3, 12 union all

    select 0, 4, 4 union all

    select 1, 4, 5 union all

    select 2, 4, 6 union all

    select 3, 4, 7 union all

    select 4, 4, 8 union all

    select 5, 4, 9 union all

    select 6, 4, 10 union all

    select 7, 4, 11 union all

    select 8, 4, 12 union all

    select 9, 4, 13 union all

    select 0, 5, 5 union all

    select 1, 5, 6 union all

    select 2, 5, 7 union all

    select 3, 5, 8 union all

    select 4, 5, 9 union all

    select 5, 5, 10 union all

    select 6, 5, 11 union all

    select 7, 5, 12 union all

    select 8, 5, 13 union all

    select 9, 5, 14 union all

    select 0, 6, 6 union all

    select 1, 6, 7 union all

    select 2, 6, 8 union all

    select 3, 6, 9 union all

    select 4, 6, 10 union all

    select 5, 6, 11 union all

    select 6, 6, 12 union all

    select 7, 6, 13 union all

    select 8, 6, 14 union all

    select 9, 6, 15 union all

    select 0, 7, 7 union all

    select 1, 7, 8 union all

    select 2, 7, 9 union all

    select 3, 7, 10 union all

    select 4, 7, 11 union all

    select 5, 7, 12 union all

    select 6, 7, 13 union all

    select 7, 7, 14 union all

    select 8, 7, 15 union all

    select 9, 7, 16 union all

    select 0, 8, 8 union all

    select 1, 8, 9 union all

    select 2, 8, 10 union all

    select 3, 8, 11 union all

    select 4, 8, 12 union all

    select 5, 8, 13 union all

    select 6, 8, 14 union all

    select 7, 8, 15 union all

    select 8, 8, 16 union all

    select 9, 8, 17 union all

    select 0, 9, 9 union all

    select 1, 9, 10 union all

    select 2, 9, 11 union all

    select 3, 9, 12 union all

    select 4, 9, 13 union all

    select 5, 9, 14 union all

    select 6, 9, 15 union all

    select 7, 9, 16 union all

    select 8, 9, 17 union all

    select 9, 9, 18;

    declare @Num1 int, @Num2 int;

    select @Num1 = 1, @Num2 = 5;

    select Sum12 as [Sum]

    from #Sums

    where Num1 = @Num1

    and Num2 = @Num2;

    The table can be extended pretty much indefinitely, of course.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon