Professional Web Applications Themes

nextMember - Microsoft SQL / MS SQL Server

"msnews.microsoft.com" <ws> wrote in message news:%23T$phx.gbl...  select min(id) from some_table where id > 45 David...

  1. #1

    Default Re: nextMember


    "msnews.microsoft.com" <ws> wrote in message
    news:%23T$phx.gbl... 

    select min(id) from some_table where id > 45

    David


    David Guest

  2. #2

    Default Re: nextMember

    Here is an example

    declare curID int
    set curID=10250

    select min(OrderID)
    from Northwind..Orders
    where OrderID>curID

    --
    -oj
    Rac v2.2 & QALite!
    http://www.rac4sql.net


    "msnews.microsoft.com" <ws> wrote in message
    news:%23T$phx.gbl... 


    oj Guest

  3. #3

    Default Re: nextMember

    How about a similar procedure to find the Previous ID?

    "oj" <com> wrote in message
    news:%23xy%phx.gbl... [/ref]
    ID's 
    >
    >[/ref]


    msnews.microsoft.com Guest

  4. #4

    Default Re: nextMember

    Sorry about having my name wrong in my news program. It should be fixed
    now. (msnews.microsoft.com is obviously not my name!)

    "oj" <com> wrote in message
    news:%23xy%phx.gbl... [/ref]
    ID's 
    >
    >[/ref]


    Josh Guest

  5. #5

    Default Re: nextMember

    Okay, those both work fine. How about the situation where I need to order
    my data first before getting the next ID? For example,
    lets say that my table has a T_Date field which the results need to be
    sorted on first before getting the next ID and prev ID?


    "oj" <com> wrote in message
    news:phx.gbl... [/ref][/ref]
    unique 
    > >
    > >[/ref]
    >
    >[/ref]


    Josh Guest

  6. #6

    Default Re: nextMember

    glad to hear you got it resolved...sorry for the late response - it's kinda
    hard to answer posts when I'm billable on client's site. <G>

    --
    -oj
    RAC v2.2 & QALite!
    http://www.rac4sql.net



    "Josh K." <ws> wrote in message
    news:%phx.gbl... [/ref]
    on. [/ref]
    based [/ref]
    T_Date [/ref]
    and 
    > Topic_ID [/ref][/ref]
    Topic_ID>curID), 
    > > unique 
    > >
    > >
    > >[/ref]
    >
    >[/ref]


    oj Guest

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