DynamicLimiting, Sql Server

Language: Layout:

create table #YourTable (ss_number int, [name] varchar(64), city varchar(64), amount int, SomeDateColumn date)

insert into #YourTable
values
(123456789,'John','Trenton',12,'20170830'),
(123456789,'John','Trenton',13,'20170830'),
(123456789,'John','Trenton',14,'20170830'),
(123456789,'John','Trenton',15,'20170830'),
(123456789,'John','Trenton',16,'20170830'),
(123456789,'John','Trenton',17,'20170830'),

(123456789,'John','Jackson',15,'20170830'),
(123456789,'John','Jackson',16,'20170830'),
(123456789,'John','Jackson',17,'20170830'),
(123456789,'John','Jackson',17,'20170830'),

(256846652,'Frank','Trenton',12,'20170830'),
(256846652,'Frank','Trenton',13,'20170830'),
(256846652,'Frank','Trenton',14,'20170830'),
(256846652,'Frank','Trenton',15,'20170830'),
(256846652,'Frank','Trenton',16,'20170830'),

(256846652,'Frank','Jackson',112,'20170830'),
(256846652,'Frank','Jackson',212,'20170830'),
(256846652,'Frank','Jackson',312,'20170830'),
(256846652,'Frank','Jackson',412,'20170830'),
(256846652,'Frank','Jackson',512,'20170830'),
(256846652,'Frank','Jackson',612,'20170830'),
(256846652,'Frank','Jackson',712,'20170830'),
(256846652,'Frank','Jackson',812,'20170830'),
(256846652,'Frank','Jackson',912,'20170830')

declare     @SearchBY varchar(64)       = 'City'            --Column to search / filter by
declare     @SearchString varchar(256)  = 'Jackson'         --Values to limit column above by
declare     @Count int                  = 9                --limit the count per each SSN
declare     @Date datetime              = '20170701'

declare @SQL nvarchar(max) =

'with cte as(
    select
        ss_number
        ,Name
        ,City
        ,Amount
        ,row_number() over (partition by ss_number order by (select 1)) as RN
    from
        #YourTable
    where
        SomeDateColumn >= ''' + convert(varchar(10),@Date,112) +
        ''' and ' + @SearchBY + ' = ''' + @SearchString +
        ''')
 select *
 from cte
 where ss_number in 
 (select distinct ss_number from cte where RN >= ' + cast(@Count as varchar(16)) + ')
 '

exec(@SQL)

drop table #YourTable

View schema
Execution time: 0,03 sec, rows selected: 14, rows affected: 24, absolute service time: 0,19 sec