Wordpress Post Counter Migration (need SQL command. simple!)

I'm currently using a wordpress plugin called "CountPosts".? I want to migrate it to wp-postviews. The two plugins store the # of views differently and I want a SQL command to migrate the data in to the new structure. Our current post views data is stored in the database as a column called post_hits in the wp_posts table. The wp-postviews plugin stores the # views in the wp_postmeta table as the meta_key called "views". I can provide the two plugins and a sample database with some content in it.? It should be pretty easy once you see the database.? I just don't remember enough SQL to write it myself, but it should be pretty easy for an experienced SQL person. Want this delivered FAST! ## Deliverables I only want the SQL statement so I can run it myself on the live site. I can provide the two plugins and a sample database to see the structure.? I know exactly what I want the SQL to do but I don't know how to write the statement myself. ## Platform mysql version 4.1.22-standard-log