Insert and Update in one storedprocedure

[GaryMazzone]

Always supply it in the SP check if > 0 then update if = 0 then Insert using an If condition on the @Id var pass the Id for the update or 0 for insert.