When I run the below query it executes correctly. But when called as a procedure throws an error

Exception assignment source returned 2 columns 42601

SELECT 
  DISTINCT A.Column-1,
  B.Column-2,
  Column-3,
  A.Column-4,
  B.Column-5,
  B.Column-6, 
  B.Column-7, 
  Column-8, 
  Column-9, 
  Column-10, 
  Column-11, 


  ( SELECT COUNT(File-1) 
    FROM Table-1 
    WHERE Column-1 = A.Column-1
  ) AS TotalFileCnt, 
  

  ( SELECT COUNT(DISTINCT File-2) 
    FROM   Table-2 
    WHERE Column-2 = B.Column-2
  ) AS ValidFileCnt, 
  

  (
    ( SELECT COUNT(File-1) 
      FROM Table-1 
      WHERE Column-1 = A.Column-1
    ) 

    ( SELECT COUNT(DISTINCT File-2) 
      FROM Table-2 
      WHERE Column-2 = B.Column-2
    )
  ) AS InvalidFileCnt, 

  
  ( SELECT COUNT(*) 
    FROM Table-2 Test 
    WHERE Test.Column-2 = B.Column-2 AND Column-5 = 'COMPLETE'
  ) AS Complete, 
  

  ( SELECT  string_agg(BB.File-N, ',' ORDER BY  BB.File-N) 
    FROM Table-1 BB 
    WHERE BB.Column-1 = A.Column-1 AND BB.File-2 NOT IN
     ( SELECT COALESCE(File-2, 0) 
        FROM Table-2 Vld 
          JOIN Table-3 Grp ON Grp.Column-2 = Vld.Column-2 
        WHERE 
          Grp.Column-1 = A.Column-1
      ) 
    GROUP BY 
      BB.Column-1
  ) AS InvalidFiles
  
FROM 
  Table-4 A 
  JOIN Table-3 B ON A.Column-1 = B.Column-1 
  JOIN Table-2 C ON B.Column-2 = C.Column-2 
WHERE 
  A.Column-4 = 'A' 
  AND A.file = 'N'