Q: ODBC vs. OLEDB for calling SQL Server stored procedures from Alteryx I have the following stored procedure in SQL Server. If I run it using OLEDB in Alteryx, I get the correct result set. However, if I run it using ODBC in Alteryx, I get this error msg:

No Columns Returned

How should I make this stored procedure work with ODBC?
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:      Saqib
-- Create date: 07/06/18
-- Description: Test of OLEDB vs. ODBC
-- =============================================
ALTER PROCEDURE [dbo].[test_sp] 
AS
BEGIN
    SET NOCOUNT ON;

    DECLARE @SQL VARCHAR(1000)

    SELECT @SQL = 'SELECT * FROM test_table'
    EXEC (@SQL)
END

