Alter PROCEDURE [dbo].[Update_Customers]
     @typeMembership aspnet_Membership_type READONLY
    AS
    BEGIN
          SET NOCOUNT ON;

          MERGE INTO aspnet_Membership c1
          USING @typeMembership c2
          ON c1.EmployeeCode=c2.EmployeeCode
          WHEN MATCHED THEN
          UPDATE SET
          c1.[EmployeeCode] =  c2.[EmployeeCode] ,
          c1.[EmployeeTypeId] = c2.[EmployeeTypeId] ,
          c1.[FirstName] = c2.[FirstName] ,
          c1.[LastName] =  c2.[LastName] ,
          c1.[Gender] =  c2.[Gender] ,
          c1.[Email] =  c2.[Email]  ,
          c1.[MobilePIN] = c2.[MobilePIN] ,
          c1.[Current_Address] =  c2.[Current_Address] ,
          c1.[Permanent_Address] =  c2.[Permanent_Address] ,
          c1.[IsApproved] = c2.[IsApproved]
          WHEN NOT MATCHED THEN
          INSERT VALUES (c2.EmployeeCode, c2.EmployeeTypeId,c2.FirstName,c2.LastName,c2.Gender,c2.Email,c2.MobilePIN,c2.Current_Address, c2.Permanent_Address,c2.IsApproved);
    END