Professional Web Applications Themes

Math Greater/Max function ?? - Microsoft SQL / MS SQL Server

Can someone help me please, I am using SQL 2000. Is there a function that can give me the bigest of two values. Example MyTable (2 Rows) Date1 Date2 ======================= ->2002-01-01 2003-01-01 ->2003-12-31 2002-12-31 Select Greater(Date1, Date2) as GreaterDate from MyTable Result (2 Rows) GreaterDate ========= 2003-01-01 2003-12-31 Thank you Christian Dubois Logilys Inc....

  1. #1

    Default Math Greater/Max function ??

    Can someone help me please,
    I am using SQL 2000.

    Is there a function that can give me the bigest of two values.

    Example

    MyTable (2 Rows)
    Date1 Date2
    =======================
    ->2002-01-01 2003-01-01
    ->2003-12-31 2002-12-31

    Select Greater(Date1, Date2) as GreaterDate from MyTable

    Result (2 Rows)

    GreaterDate
    =========
    2003-01-01
    2003-12-31

    Thank you
    Christian Dubois
    Logilys Inc.


    Christian Guest

  2. #2

    Default Re: Math Greater/Max function ??

    Hi Christian,

    There is no such function in T-SQL, but you can easily simulate it with
    CASE:

    SELECT CASE WHEN Date1 > Date2 THEN Date1 ELSE Date2 END AS GreaterDate
    FROM Mytable

    --
    Jacco Schalkwijk MCDBA, MCSD, MCSE
    Database Administrator
    Eurostop Ltd.


    "Christian Dubois" <com> wrote in message
    news:phx.gbl... 


    Jacco Guest

  3. #3

    Default Re: Math Greater/Max function ??

    Use CASE and one of the following methods:

    If you don't have NULLs in the data:
    SELECT
    CASE
    WHEN date1 > date2
    THEN date1
    ELSE date2
    END
    FROM MyTable

    If you want the highest non-NULL value:
    SELECT
    CASE
    WHEN date1 > date2
    THEN date1
    ELSE COALESCE(date2,date1)
    END
    FROM MyTable

    If you want to return NULL where one of the dates is NULL
    SELECT
    CASE
    WHEN date1 > date2 OR date1 IS NULL
    THEN date1
    ELSE date2
    END
    FROM MyTable

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --


    David Guest

Similar Threads

  1. Simple Math function
    By TommyMTL in forum Coldfusion - Getting Started
    Replies: 3
    Last Post: April 1st, 02:57 AM
  2. Some math function
    By ED_R in forum Macromedia Flash Actionscript
    Replies: 0
    Last Post: February 21st, 06:00 PM
  3. Replies: 4
    Last Post: December 19th, 07:09 AM
  4. Math function error
    By AMADIUM in forum UNIX Programming
    Replies: 3
    Last Post: June 30th, 11:19 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139