select opr.ownerId, opr.fsltablecode, opr.operatorId, opr.companyName, opr.address, opr.city, opr.state, opr.zipcode, opr.crmActive from tbl_OPR_ClientOperators opr with (nolock) where ( opr.ownerId <> 14 and opr.fsltablecode <> 'BRO' ) and opr.companyName = and opr.address = and opr.city = and opr.state = and opr.zipcode = SELECT bro.BROKER_NAME AS name FROM tblBrokers bro WHERE bro.broker_Id = SELECT mfr.MFR_NAME AS name FROM tblManufacturers mfr WHERE mfr.mfr_id = SELECT cho.cho_name AS name FROM tbl_CHO_Operators cho WHERE cho.cho_id = SELECT msc.company AS name FROM tbl_MSC_FSLibraryUsers msc WHERE msc.userId = SELECT dst.dstname AS name FROM tbl_DST_Distributors dst WHERE dstId = theDir = GetDirectoryFromPath( GetCurrentTemplatePath() ); theFile = theDir & attributes.fileName; theSheet = SpreadsheetNew( "Matched Operators" ); SpreadsheetAddColumn( theSheet, "FSL Account", 1, 1, true ); SpreadsheetAddColumn( theSheet, "Operator ID", 1, 2, true ); SpreadsheetAddColumn( theSheet, "Operator", 1, 3, true ); SpreadsheetAddColumn( theSheet, "Matched OwnerType", 1, 4, true ); SpreadsheetAddColumn( theSheet, "Matched FSL Account", 1, 5, true ); SpreadsheetAddColumn( theSheet, "Matched OperatorId", 1, 6, true ); SpreadsheetAddColumn( theSheet, "Matched Operator", 1, 7, true ); SpreadsheetAddColumn( theSheet, "Matched CRM Active", 1, 8, true ); SpreadsheetAddRows( theSheet, qmd_matches );