Stored procedure to automate mapping and transformation

I have a work related problem. I need help to come up with mapping and transform data base elements to automate the process using stored procedure (sql server)