Post reply

Using SET, ORDER BY and TOP together to populate a variable

  • October 9, 2007 at 3:15 am

    #62080

    Hi,

    I am trying to set a value from the following SELECT statement but I am getting an error:

    DECLARE @tmp varchar (20)

    SET @tmp = TOP 1 Value FROM Table ORDER BY NewID()

    but I am getting an error near the keyword 'TOP'

    Is this sort of statement possible or is there an alternative way to achieve what I am doing. By the way I am using the ORDER by NewID() to randomly select from a table.

    Cheers,

    Chris

  • October 9, 2007 at 3:21 am

    #740268

    Manage to solve it myself - missing the brackets.

    Should be: SET @tmp = (SELECT TOP 1 Value FROM Table ORDER BY NewID())

  • October 9, 2007 at 4:25 am

    #740282

    little better....

    SELECT TOP 1 @tmp = Value FROM Table ORDER BY NewID()

    --Ramesh

  • October 9, 2007 at 6:06 am

    #740309

    Thanks Ramesh, I forgot variables could be assigned that way.

    Cheers,

    Chris

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply