spGetAppealDuplicateStats
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @Appealid | int | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spGetAppealDuplicateStats]
(@Appealid int)
as
DECLARE @Counts TABLE (DupCount int, ListID int)
INSERT INTO @Counts
SELECT count(epd.ID) as DuplicateRecordCount, epd.EmailListID
FROM [EmailProjectAppeal_Duplicates] epd
WHERE emailprojectappealid = @Appealid
GROUP BY epd.EmailListID
ORDER BY epd.EmailListID
SELECT el.ID,el.Name, DupCount as DuplicateRecordCount FROM @Counts cnt inner join emaillist el on cnt.listID = el.ID