You might have to put this in a stored procedure and EXECUTE WITH RESULTS SETS where you define the schema expected. Here is MS's example

EXEC uspGetEmployeeManagers 16
WITH RESULT SETS
( 
 ([Reporting Level] int NOT NULL,
  [ID of Employee] int NOT NULL,
  [Employee First Name] nvarchar(50) NOT NULL,
  [Employee Last Name] nvarchar(50) NOT NULL,
  [Employee ID of Manager] nvarchar(max) NOT NULL,
  [Manager First Name] nvarchar(50) NOT NULL,
  [Manager Last Name] nvarchar(50) NOT NULL )
);