Need To Store Duplicate Values To DB

Hi,
I have written a stored procedure to store values from a report i generated to the DB. Now there is a column PKID which is the primary key but also needs to be repeated at times. I tried to clear the memory that the same PKID has already been entered for which I wrote another SP.
 
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spCRMPublisherSummaryUpdate](
    @ReportDate smalldatetime,
    @SiteID int,
    @DataFeedID int,
    @FromCode varchar,
    @Sent int,
    @Delivered int,
    @TotalOpens REAL,
    @UniqueUserOpens REAL,
    @UniqueUserMessageClicks REAL,
    @Unsubscribes REAL,
    @Bounces REAL,
    @UniqueUserLinkClicks REAL,
    @TotalLinkClicks REAL,
    @SpamComplaints int,
    @Cost int
)
AS
SET NOCOUNT ON
   
DECLARE @PKID INT
DECLARE @TagID INT

SELECT @TagID=ID FROM Tag WHERE SiteID=@SiteID AND FromCode=@FromCode

SELECT @PKID=PKID FROM DimTag
WHERE TagID=@TagID AND StartDate<=@ReportDate AND @ReportDate< ISNULL(EndDate,'12/31/2050')
IF @PKID IS NULL BEGIN
    SELECT TOP 1 @PKID=PKID FROM DimTag WHERE TagID=@TagID AND SiteID=@SiteID

DECLARE @LastReportDate smalldatetime, @LastSent INT, @LastDelivered INT, @LastTotalOpens Real,
@LastUniqueUserOpens Real, @LastUniqueUserMessageClicks Real, @LastUniqueUserLinkClicks Real,
@LastTotalLinkClicks Real, @LastUnsubscribes Real, @LastBounces Real, @LastSpamComplaints INT, @LastCost INT

SELECT @Sent=@Sent-Sent,@Delivered=@Delivered-Delivered,@TotalOpens=@TotalOpens-TotalOpens,
@UniqueUserOpens=@UniqueUserOpens-UniqueUserOpens,@UniqueUserMessageClicks=@UniqueUserMessageClicks-UniqueUserMessageClicks,
@UniqueUserLinkClicks=@UniqueUserLinkClicks-UniqueUserLinkClicks,@TotalLinkClicks=@TotalLinkClicks-TotalLinkClicks,
@Unsubscribes=@Unsubscribes-Unsubscribes,@Bounces=@Bounces-Bounces,@SpamComplaints=@SpamComplaints-SpamComplaints,
@Cost=@Cost-Cost
    FROM CrmPublisherSummary
        WHERE @LastReportDate < @ReportDate
        AND SiteID=@SiteID
        AND TagPKID=@PKID

UPDATE CrmPublisherSummary SET
    Sent=@Sent,
    Delivered=@Delivered,
    TotalOpens=@TotalOpens,
    UniqueUserOpens=@UniqueUserOpens,
    UniqueUserMessageClicks=@UniqueUserMessageClicks,
    UniqueUserLinkClicks=@UniqueUserLinkClicks,
    TotalLinkClicks=@TotalLinkClicks,
    Unsubscribes=@Unsubscribes,
    Bounces=@Bounces,
    SpamComplaints=@SpamComplaints,
    Cost=@Cost,
    TagID=@TagID
    WHERE ReportDate=@ReportDate
        AND SiteID=@SiteID
        AND TagPKID=@PKID
END

ELSE
   
    INSERT INTO CrmPublisherSummary(
    ReportDate, SiteID, TagPKID, Sent, Delivered, TotalOpens, UniqueUserOpens,
    UniqueUserMessageClicks, UniqueUserLinkClicks, TotalLinkClicks, Unsubscribes,
    Bounces, SpamComplaints, Cost, DataFeedID, TagID)
   
    VALUES(
    @ReportDate, @SiteID, @PKID, @Sent, @Delivered, @TotalOpens, @UniqueUserOpens,
    @UniqueUserMessageClicks, @UniqueUserLinkClicks, @TotalLinkClicks, @Unsubscribes,
    @Bounces, @SpamComplaints, @Cost, @DataFeedID, @TagID)

SET NOCOUNT OFF


 
this is the one to clear:
 SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[spCRMPublisherSummaryClear](
    @SiteID INT,
    @DataFeedID INT,
    @ReportDate SMALLDATETIME) AS

    DELETE LandingSiteSummary
        WHERE SiteID=@SiteID AND ReportDate=@ReportDate


but it doesnt seem to be working.
Please suggest.