Professional Web Applications Themes

Put in priority order - Microsoft SQL / MS SQL Server

Dear all, Please... I need a help. I need to put in priority order. For example: I have same teams in a specific table. I need choose one of them, but I have same details. In the first I want team A1, if this team not found the system must be show me team A2.... For exemple: Marta Morais - team A1 has a Priority 1 Ana Maria - team A2 has a Priority 2 In symmary... If the querie found both I want see only one of them: Marta Morais - team A1 has a Priority 1 Tks...

Sponsored Links
  1. #1

    Default Put in priority order

    Dear all,
    Please... I need a help. I need to put in priority order.
    For example: I have same teams in a specific table.
    I need choose one of them, but I have same details.
    In the first I want team A1, if this team not found the
    system must be show me team A2....
    For exemple:
    Marta Morais - team A1 has a Priority 1
    Ana Maria - team A2 has a Priority 2
    In symmary... If the querie found both I want see only one
    of them: Marta Morais - team A1 has a Priority 1
    Tks
    Sponsored Links
    Marta Guest

  2. #2

    Default Re: Put in priority order

    SELECT *
    FROM Sometable
    WHERE team = 'A1'
    OR (team = 'A2' AND
    NOT EXISTS
    (SELECT *
    FROM Sometable
    WHERE team='A1') )

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

    "Marta Morais" <com> wrote in message
    news:0be401c34ae4$366d2f70$gbl... 


    David Guest

  3. #3

    Default Put in priority order

    Maybe this will help:

    SELECT TOP 1 * FROM teams ORDER BY priority
    Michal Guest

Similar Threads

  1. Priority Caching
    By mrgfunk in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: February 16th, 06:00 PM
  2. loading with priority
    By Phatty in forum Macromedia Flash
    Replies: 0
    Last Post: June 16th, 12:46 AM
  3. priority queue
    By j in forum PERL Miscellaneous
    Replies: 2
    Last Post: July 23rd, 10:07 PM
  4. how to give priority to a nic
    By Robert L [MS-MVP] in forum Windows Networking
    Replies: 0
    Last Post: July 16th, 01:52 PM
  5. TCP-IP high priority ove IPX
    By mara in forum Windows Networking
    Replies: 1
    Last Post: July 2nd, 06:17 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