Professional Web Applications Themes

How to Pick a Random Record? - Microsoft SQL / MS SQL Server

Hello, I'm trying to pick a random record out of a table, with SITEID of many sites. I would like to be able to get a random record from records with a SITEID of 1. Any help would be great! Thanks, Jack...

  1. #1

    Default How to Pick a Random Record?

    Hello,

    I'm trying to pick a random record out of a table, with SITEID of many
    sites. I would like to be able to get a random record from records with a
    SITEID of 1.

    Any help would be great!

    Thanks,

    Jack


    Jack Guest

  2. #2

    Default Re: How to Pick a Random Record?

    Jack,

    See

    How can I select random rows from a SQL Server table?
    http://www.mssqlserver.com/faq/development-randomrows.asp


    --
    Dinesh.
    SQL Server FAQ at
    http://www.tkdinesh.com

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


    Dinesh.T.K Guest

  3. #3

    Default Re: How to Pick a Random Record?

    http://www.aspfaq.com/2132






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


    Aaron Guest

Similar Threads

  1. Random record
    By barbedwire103 in forum Dreamweaver AppDev
    Replies: 4
    Last Post: June 13th, 12:29 PM
  2. Choose a random record
    By J?J in forum Macromedia ColdFusion
    Replies: 0
    Last Post: March 27th, 07:55 PM
  3. random record from small set
    By Jeff in forum PostgreSQL / PGSQL
    Replies: 5
    Last Post: February 15th, 04:15 PM
  4. pick N random lines from a file
    By David Garamond in forum PERL Beginners
    Replies: 2
    Last Post: December 10th, 07:27 PM
  5. random pick from list
    By Shane in forum Macromedia Director Lingo
    Replies: 0
    Last Post: August 13th, 01:47 AM

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