i am running this from oracle

Third, what doesn't work? what does "well" mean? Please include enough information and ask a specific question so people can help you.

inserting the result set from the query...

THAT WORKED THANKS

THE ERROR I'M GETTING IS 'LITERAL DOES NOT MATCH FORMAT STRING' I AM RUNNING THIS ON ORACLE AND I CHANGED THE WORD COUNT TO CNT AND IT STILL DOES...

i did create the temp table first then try to insert the data into it. as for using open quesry i am trying to get away from it. ...

i did createa temp table and a global table but when i try to insert the data i get eh error incorrect syntax near execute

the oracle statement works fine (i ran it separetly in sql 2005). but when i run the script as a whole in SQL 2005 i get his error...