Вот пример, как обусловить горизонатльный фильтр (where clause) в SQL.

declare @bViewAll int
set @bViewAll = 1

create table #appr (time_id int)

if @bViewAll = 1
begin
insert into #appr
select top 100 time_id
from dbo.securitiesResults
end
else
insert into #appr
select top 100 time_id
from dbo.securitiesResults
where time_id = 250

select * from #appr

drop table #appr