Post reply

maximum of 2 values

  • December 1, 2006 at 7:34 am

    #114771

    isn't there smthg in t-sql to get the maximum value between 2 dates like in any other language??!!!!

    insert into table(field) values max(var1,var2)

     

  • December 1, 2006 at 7:47 am

    #675130

    INSERT INTO Table(Field) SELECT CASE WHEN @Var1 > @Var2 THEN @Var1 ELSE @Var2 END AS Field

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply