A step by step tutorial[
^].
The short of it...
create procedure [procedure_name]
@status char(1)
as
select someStuff
from someTable
where status = @status
end
This SP returns someStuff from someTable where the status is equal to the parameter provided.
Hope that helps! :)
Edit:
I may imply that only simple select statements are possible in an SP. This is not the case however, you can do joins, updates, deletes, use cursors, loops, temp tables, practically do anything in an SP. It doesn't necissarily need a return value either.