using variable with the TOP keyword in the SQL procedure

• lss

  SSC-Addicted

  Points: 431

  More actions

  April 29, 2004 at 9:40 pm

  #108292

  Hi,

  This is my code:

  CREATE PROCEDURE test2 (@number int)

   AS

  select top @number field1 from table A

  order by field1

     I can't save the stored procedure. I want to passing one number into this procedure so that it can generate the result for me. The number is dynamic. Please kindly advice.

   

   

  Thanks and Regards

  lss

  lss

• AH

  SSC Veteran

  Points: 267

  More actions

  April 30, 2004 at 3:18 am

  #504784

  exec('select top ' + @number + ' field1 from table A

  order by field1')