Assuming that the zero values really are nulls in the database then I suggest the following:-

select

coalesce( col1, 0 ) col1,

coalesce( col2, 0 ) col2,

coalesce( col3, 0 ) col3

from data

order by...

If it would make sense in your context, you could call one stored procedure from another.

Thus Procedure A calls Procedure B and then uses the output from Procedure B to...

You could use Query analyser.  Right-click on the table you want to create the insert statement for and select 'Script Object to new window' and choose the 'insert' option.