>We have two different SQL servers. I need to write a SQL procedure to select a list from a table in server-1 and insert into a table in server-2. Can this be done from within a procedure?

Yes. You can use OPENQUERY, OPENROWSET, or set up the other server as a linked server and include it in the four-part name (Server.Database.Schema.Object).