Viewing post 1 (of 2 total)
two ways
1
DECLARE @top int
SET @top = 100
SET ROWCOUNT @top
SELECT policynumbers FROM tblpolicynumbers
SET ROWCOUNT 0
2
DECLARE @top INT
EXEC('SELECT TOP ' + @top + ' policynumbers FROM tbl')
October 26, 2007 at 2:52 am
#745620