خرید بک لینک

Vote count: 0

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.

asked 1 min ago

برچسب: نویسنده: استخدام کار تاريخ: پنجشنبه 16 ارديبهشت 1395 ساعت: 0:44

صفحه بندی