Kevin,

Here's a very simple stored proc to return the entire customer record for a customer PK...

CREATE PROCEDURE GetCustomerByPK (@nCustomerPK int)
 AS

	SELECT * FROM Customer WHERE CustomerPK = @nCustomerPK
GO

You may want to check BOL (books online) for more details on creating SPs.

Kevin