I want this data to go into a new table,
<cfquery name="new" datasource="healthmart98" dbtype="ODBC">
SELECT
Provider,DRGCD,Total_Cases,PCDTHS,Expected_PCDTH,PCDTH_Rating,AvgLOS,MedLOS,
MaxLOS,MinLOS,Expected_LOS,LOS_Rating,AvgCHG,MedCHG,MaxCHG,MinCHG,Expected_C
HG,CHG_Rating
FROM Region10Hospitals
</cfquery>
<cfinsert datasource="healthmart98" tablename="region10severity"
dbtype="ODBC" dbname="healthmart98"
formfields="Provider,DRGCD,Total_Cases,PCDTHS,Expected_PCDTH,PCDTH_Rating,Av
gLOS,MedLOS,MaxLOS,MinLOS,Expected_LOS,LOS_Rating,AvgCHG,MedCHG,MaxCHG,MinCH
G,Expected_CHG,CHG_Rating">
Is this right?
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
