declare @rows int
exec @rows = dbo.numaircrafts 400
select @rows 'number of rows returned' 