Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: Dynamic "TOP" values in select statements

    two ways

    1

    DECLARE @top int

    SET @top = 100

    SET ROWCOUNT @top

    SELECT policynumbers FROM tblpolicynumbers

    SET ROWCOUNT 0

    2

    DECLARE @top INT

    SET @top = 100

    EXEC('SELECT TOP ' + @top + ' policynumbers FROM tbl')

Viewing post 1 (of 2 total)