Looping With File Output

I'm converting a terribly written ColdFusion script and migrating it to T-SQL (SQL Server 2012). My problem is, I'm having issues with how to get these loops sorted out. For instaces, the CF query wouold be something like :

<cfquery name = "getData" datasource = "db">
SELECT id, name, date FROM table
</cfquery>

Following that, this query is looped into another set of queries:

<cfloop query = "getData">
<cfquery name = "getAddress" datasource = "globaladdress">
select * from globalAddress
where addressID = '#addressID#'
</cfquery>

[code]...

What I'm looking to do is turn the first query "getData" into the above loop, but rather in T-SQL.