I have a temp table which created and filled as below:
DECLARE @WALKINS TABLE (WorkId Int, EmployeeId INT, MembId Int)
INSERT @WALKINS
SELECT WorkId = WORK_ID,
EmployeeId = EMPL_ID,
MembId = WORKS.MEMB_ID
FROM CARS.DBO.WORK_Worksheets WORKS
WHERE WORKS.WORK_ID NOT IN ( SELECT WORS.WORK_ID
FROM CARS.DBO.WORS_WorksheetsLeads WORS
INNER JOIN CARS.DBO.LEAD_Leads LEAD ON LEAD.LEAD_ID = WORS.LEAD_ID AND WORS.WORK_ID IS NOT NULL
INNER JOIN COM.DBO.CNTL_ContactCenterLeads CNTL ON LEAD.LEAD_OldCode = CNTL.CNTL_ID)
AND WORKS.WORK_CreatedDate BETWEEN '4/1/2016' AND '4/27/2016'
AND WORKS.EMPL_ID = 110629
the problem is there are duplicate WORKS.MEMB_ID and I want to insert just unique Memb_ids in to that @WALKINS table.
