Post reply

Query Help

  • February 14, 2007 at 12:28 pm

    #172036

    Hello,

    I am trying to generate a table in sql server 2000 that pulls x number of random assets per category from a table. 

    I have already generated a process that produces two tables.  One table has two fields: CATEGORY_NAME and ASSETS_NEEDED_FOR_ASSIGNMENT.  The other table is a list of all the assets I can choose from.  The field names are: ASSET_NUM, CATEGORY_NAME, RANDOM_NUM.

    My goal is to pull the top X number of random assets per category based on the random number.  I know that 2005 solves this issue, however, any ideas on how this can be accomplished with 2000?

    Thanks in advance,

    Roland

    Kindest Regards,

  • February 14, 2007 at 12:32 pm

    #689799

    test

    Kindest Regards,

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

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