I'm crashing my server with a CFLOOP command that loops through a query result
set(query of queries). Is there anyway that I can insert ALL of the records
with ONE query? My only idea so far would involve accessing BOTH the query
result set AND the actual datasource in the same query; is there a way to do
this. My code right now looks like this:

<cfquery datasource="myDS">
SELECT COL1,COL2,COL3
INTO DATASOURCE_TABLE
FROM QUERY_RESULT_SET
</cfquery>

Is there a way to do the insertion WITHOUT looping and crashing my server?