newbie SP question

From: Miguel Salles (MiguelSalles_at_discussions.microsoft.com)
Date: 12/20/04 

Date: Mon, 20 Dec 2004 05:01:01 -0800

Hi, I'd like to create a SP like this:
SP_Table1_LOAD
Update Table1 set... (alter existing rows)
Insert Into Table1... (insert new rows)

This table is a dimension on my DW, I'm used to do this with DTS but I have
never used Stored Procedures before.

Can anyone please help me?
Thanks