-- Lấy DS Sale
    EXEC PowerInfo..MobiSale_GetSaleList
        @pAccountSale = 'isc.haipv7' -- varchar(50)    

-- Báo cáo HĐ Khách hàng rời mạng
EXEC MobiSale_ReportSuspendCustomer
            @UserName='isc.haipv7', @Agent=0,@AgentName='',
            @PageNumber=1, @Month=6, @Year=2022, @Dept=0

-- Báo cáo HĐ Khách hàng rời mạng chi tiết theo Sale
EXEC dbo.MobiSale_ReportSuspendCustomerDetail  
    @UserName = 'isc.hieupc1',  -- varchar(50)
    @PageNumber = 1, -- int
    @Month = 6,      -- int
    @Year = 2022        -- int

-- Lay Bao cao roi mang - SalesID => salename
        SELECT TOP 1000 ObjID,SalesID, 1 as ss
                FROM Internet.dbo.SS_SuspendCus(nolock)  
                WHERE Month = 6 AND Year = 2022
                UNION
                SELECT ObjID,SalesID, 2 as ss
                FROM Powerdata..SS_BoxITV_Suspend(nolock)  
                WHERE Month = 6 AND Year = 2022