I'm attempting to write a stored procedure that can read from a file and act on the contents I have a text file filled with SELECT statements that I would like to reference from a stored procedure. This is what my text file looks like:

SELECT '4200100116' AS [SRC_GEOID]
       ,SUM([Workers_in_Flow]) 
FROM [table] 
WHERE [DEST_GEOID] IN ('4200100116'
                      ,'4200105880'
                      ,'4200132144'
                      ,'4213357872')


I want to iterate through the text file and run these commands and append the results to a table. Is this possible? If so, how?

I've looked into T-SQL and gotten conflicting ideas on whether that's what I want or not. Also, I've learned about BULK INSERT but that seems to be more about inserting into a table whereas I want to run the actual commands and append the results.
This can be done simply with powershell. Use get-content to get queries from file, invoke-sqlcmd to run the queries, and write-sqltabledata to output results to table. Save example below to .ps1 and run in powershell session passing the path to file with queries. (ex. C:\you\powershell> .\run-tsql.ps1 C:\temp\sql_queries.txt)

#paramter passed to script
param( [string] $auditlist)

#read contents of file
$queries = Get-Content $auditlist

#adds sql server module to get the sql server commands
import-module sqlserver

#cycle though all results retrived from file
foreach ($query in $queries)
{
    #run each command and load into table
    Invoke-Sqlcmd -serverinstance &lt;instance name&gt; -database &lt;databasename&gt; -query $query -OutputAs DataTables |Write-SqlTableData -ServerInstance &lt;instance name&gt; -DatabaseName &lt;dbname&gt; -SchemaName &lt;schema&gt; -TableName &lt;table&gt;
}