Adding Random values to rows

Results 1 to 2 of 2

Thread: Adding Random values to rows

  1. #1
    Join Date
    Dec 1969

    Default Adding Random values to rows

    Hi,<BR><BR>I need to add a random number to each line of a SQL 7 query. The query is of the format &#039;SELECT ID, Name, Rand(1000) as MyRandomNr FROM tblMyData&#039;. At the moment each MyRandomNr in each row contains the exact same number. <BR><BR>Does anybody have any ideas on how to get this value to vary? I need to get this working through the query, and not by manipulating the data through my ASPcode.<BR><BR>Does anybody have an idea how to get this to work???<BR><BR>Thanks in advance,<BR><BR>Ken

  2. #2
    Wild J Guest

    Default RE: Adding Random values to rows

    Check these articles out this should point you in the right direction.<BR><BR>

Posting Permissions

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