Try creating the table and then inserting into it; this should allow you to select the values into a variable and into the table at the same time.

But you can only do this for one row at a time, right? I guess I'm having a little trouble figuring out what you're trying to do.

Create Table temp1 ([0306] decimal (5,2),[0307](5,2), [0308] decimal (5,2), [0309] decimal (5,2))

Insert temp1

SELECT Distinct

TOP 100 PERCENT

Month1 / Month1 AS [0306],

Month2 / Month1 AS [0307],

Month3 / Month1 AS [0308],

Month4 / Month1 AS [0309]

FROM dbo.TESTJune2003