You can use some SQL like this one :
INSERT INTO tabl1 (col1, col2, ...)
SELECT col1, cast(col2 as int), ...
FROM table1
WHERE Col1 = 1
The
cast
is doing the convert operation for you.
Repeat this statement for all three tables.
Also consider reading these pages :
http://msdn.microsoft.com/en-us/library/ms188263.aspx[
^]
http://devguru.com/technologies/t-sql/7124.asp[
^]
I'm sure that converting these three statements into a storedprocedure is the easiest part for you.
Hope it helps.