Listing 1
CREATE PROCEDURE copystates
@statedata varchar(8000)
AS
DECLARE @hDoc int
exec sp_xml_preparedocument @hDoc OUTPUT, @statedata
INSERT INTO StatesArchive
SELECT *
FROM OPENXML(@hDoc,'/ALLSTATES/STATES')
WITH testtable
EXEC sp_xml_removedocument @hDoc
GO

Listing 2
<CFHTTP METHOD="GET"
URL="http://127.0.0.1/
cfdj_sqlserver2K?SQL=SELECT+*+FROM+STATES+FOR+XML+AUTO
&ROOT=ALLSTATES">
<CFSET temp = ListDeleteAt(CFHTTP.FileContent, 1, ">")>

<CFQUERY DATASOURCE="CFDJ" NAME="copystates">
{ call copystates ('#Trim(temp)#') }
</CFQUERY>