You can do it without dynamic sql using SSMS. For any table, click on the Columns heading and drag to the query window. You'll get all the columns separated by commas. Next, type "0," ten times, then copy what you have and paste it on the end of itself 9 times. Now you have all the column names and ninety zeros to match.
Put them in their proper places in an INSERT statement and you're done:
INSERT INTO yourtable (...drag and drop column list here...)
SELECT ...90 copies of "0,"...
Now, you only have to take care of the one column you really want to control. Find it in the column list and move it to the front of the list, then change your select to
SELECT @mydata, ...89 copies of "0,"...