SET @sql = 'SELECT SUBSTR(B.CUSTNO,1,15) as CUSTNO,SUBSTR(B.CUSTNO,2,6) as CUSTNO6,B.AMOUNT as AMOUNT,B.TRANTYPE as TRANTYPE, SUBSTR(H.TEAM,1,10) as TEAM,H.COLLNAME AS PORTFOLIONAME,A.COLLTYPE AS CUSTTYPE,A.COMPANY as COMPANY,C.PROBLEM_ID AS ProblemID,C.GROUP_ID AS GroupID,SUBSTR(C.UCONTENT01,1,255) AS DisputeDesc, E.DESCRIPTION AS ReasonCategory,D.PDESC AS Reason,G.GROUP_NAME AS OwnerCategory,GPUSER_2.FULLNAME AS Owner1,C.SALESAREA AS SalesArea,TO_CHAR(C.DE_DATE,''YYYY/MM/DD'') AS EscalationDate,I.RESNAME AS Resolver, (WITH groupdata AS ( SELECT l1.created_on, l1.group_id, l1.salesid, l1.status, row_number() over (PARTITION BY l1.group_id ORDER BY l1.created_on DESC) AS grouprow FROM gpcomp1.gpproblog l1 WHERE l1.paydate IS NULL AND l1.closedate IS NULL AND l1.group_id = 2062335 ) SELECT mx.group_id, ( SELECT created_on FROM groupdata chg WHERE chg.group_id = mx.group_id AND chg.grouprow = CHANGE.changerow - 1 ) AS earliestdate FROM groupdata mx cross apply ( SELECT min(grouprow) FROM groupdata chg WHERE chg.group_id = mx.group_id AND ( chg.salesid <> mx.salesid OR chg.status <> mx.status ) ) CHANGE(changerow) WHERE mx.grouprow = 1) AS statusdateminmax, ''0'' as StatusDateMin, ''0'' as StatusDateDefault, M.DESCRIPTION AS StatusName,SUBSTR(C.UCONTENT02,1,30) AS ProblemExtended,SUBSTR(C.UCONTENT03,1,255) AS NextStep,SUBSTR(C.UCONTENT04,1,255) AS Required1,B.FLEXDATE3 AS FlexDate3, '' '' as DisputeReasonCatCode, D.PCODE as DisputeReasonCode,'' '' as OwnerCategoryCode,'' '' as Owner1Code,C.Dispute_Amt AS DisputeAmt,GPCOMP1.GetGPNotes(C.rowid,C.PROBLEM_ID) as ProblemNote FROM GPCOMP1.GPCUST A,GPCOMP1.GPRECL B,GPCOMP1.GPPROB C,GPCOMP1.GPPCAT D,GPCOMP1.GPREACAT E,GPCOMP1.GPCOLL H,GPCOMP1.GPRESLVR I,GPGLOBAL.GPUSERLIC GPUSER_1,GPGLOBAL.GPUSERLIC F, GPCOMP1.GPSTATUS M,GPGLOBAL.GPGROUP G,GPGLOBAL.GPUSERLIC GPUSER_2,GPGLOBAL.GPUSERGROUPMAP P,GPGLOBAL.GPUSER_GROUP_ENTITLEMENT Q WHERE B.CUSTNO = A.CUSTNO AND B.TRAN_ID = C.OPEN_INVOICE_TRAN_ID AND C.PCODE = D.PCODE AND D.REASCAT = E.CATEGORY AND A.COLLECTOR = H.COLLCODE AND C.RESOLVER = I.RESCODE AND (C.MODIFIED_BY = GPUSER_1.USERLIC_ID) AND (C.CREATED_BY = F.USERLIC_ID) AND (NOT (C.PROBLEM_ID IS NULL)) AND C.STATUS = M.CODE AND (C.SALESID = GPUSER_2.NAMED_USER) AND (P.USERLIC_ID = GPUSER_2.USERLIC_ID) AND G.GROUP_ID = P.GROUP_ID AND G.GROUP_ID = Q.GROUP_ID AND Q.ENTITLEMENT IN (''DRS_USER.CAN_BE_PROB_OWNER'',''GP_COLLECTOR.CAN_BE_PROB_OWNER'',''GP_RESOLVER.CAN_BE_PROB_OWNER'',''CM_USER.CAN_BE_PROB_OWNER'') AND A.INACTIVE = ''N'' AND C.CLOSEDATE is null ' SET @sql = N'INSERT INTO [#IssuesDetails] SELECT * from openquery ([GTPFR], ''' + Replace(@sql, '''', '''''') + ''')' EXEC (@sql)