Stored Procedure to run query and insert

[charlesg]

I have a query that select rows from the employees,salar y_head and salary_group tables
this is the query
SELECT TOP 100 PERCENT dbo.salary_head .salary_group_i d, dbo.salary_grou p.salary_group, dbo.salary_head .amount, dbo.grade_level .[level],
dbo.employees.e mploy_name, dbo.employees.w ork_id, dbo.employees.c ompany_id, dbo.employees.d esignation, dbo.salary_head .level_id,
dbo.employees.t erminate, dbo.employees.b anks_id, dbo.employees.b ank_account_no
FROM dbo.employees INNER JOIN
dbo.salary_head INNER JOIN
dbo.salary_grou p ON dbo.salary_head .salary_group_i d = dbo.salary_grou p.salary_group_ id ON
dbo.employees.l evel_id = dbo.salary_head .level_id INNER JOIN
dbo.grade_level ON dbo.employees.l evel_id = dbo.grade_level .level_id
ORDER BY dbo.grade_level .level_no DESC, dbo.salary_head .salary_group_i d
i also have a table called payrollers1 with the following fields
payroll_id int auto
payperiod_id int
employee_id
level_id
designation_id
banks_id
bankaccount_no
salarygroup_id
Amount
I am trying to write a stored procedure that will run the above query and then insert the values of the employee_id,lev el_id,designati on_id,salary_gr oup_id,amount rows into the payroller table.
As for the payperiod_id i want the Stored procedure to look up the max payperiod value.
I am totally new to stored procedure and do not know how to write this code.
Can somebody help me with this code.
Regards
charles