How to execute multiple script procedures in sql server

Below is my select query written in SQL SERVER

select 'exec pr_tblmaster_split ''tblmaster_'+  Cast(year_id as nvarchar(4000)) +'''' as qry
from  tblmaster
group by year_id 
order by year_id asc

      

        
        
        
      

    

and it will return

qry
-------------------------------------
exec pr_tblmaster_split 'tblmaster_1'
exec pr_tblmaster_split 'tblmaster_2'

      

        
        
        
      

    

So my question is, how can I trigger a return request using a function / procedure ?.

I am trying to convert PostgreSQL to SQL Server, so

In PostgreSQL I can use FOR LOOP like this

declare 
rw record;
begin
  for rw in 
         select 'select fn_tblmaster_spliting(''tblmaster_'||t.tbl||''');' crTables from (
         select distinct(year_id) tbl from tblmaster order by acyrid asc)t
   loop
         execute rw.crTables;
   end loop;
   end