insert update select storprocedure

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[AddUpdateCustomer]

      @CustomerID NCHAR(5),

      @ContactName NVARCHAR(30),

      @CompanyName NVARCHAR(40)

AS

BEGIN

      SET NOCOUNT ON;

    IF EXISTS(SELECT * FROM Customers WHERE CustomerID = @CustomerID)

    BEGIN

            UPDATE [Customers]

            SET [CompanyName] = @CompanyName

               ,[ContactName] = @ContactName

            WHERE CustomerID = @CustomerID

    END

    ELSE

    BEGIN

            INSERT INTO [Customers]

           ([CustomerID]

           ,[CompanyName]

           ,[ContactName])

        VALUES

           (@CustomerID

           ,@CompanyName

           ,@ContactName)

    END

   

    SELECT [CustomerID]

          ,[CompanyName]

          ,[ContactName]

      FROM Customers         

END

Delete duplicate record in database

1:-

DELETE FROM dbo.ATTENDANCE WHERE AUTOID NOT IN (SELECT MIN(AUTOID) _
 FROM dbo.ATTENDANCE GROUP BY EMPLOYEE_ID,ATTENDANCE_DATE) 

2.

WITH TempUsers (FirstName,LastName, duplicateRecordCount)

AS

(

SELECT FirstName,LastName,

ROW_NUMBER()OVER(PARTITIONBY FirstName, LastName ORDERBY FirstName) AS duplicateRecordCount

FROM dbo.Users

)

DELETE

FROM TempUsers

WHERE duplicateRecordCount > 1

GO