pcsoft.us.windevCopyright 2026, PC SOFT20 Feb 2021 08:56:22 Z20 Feb 2021 08:15:34 ZHi, Anyone tried retrieving output of MSSQL stored procedure with 2 different result here is the sample of stored procedure ALTER PROCEDURE [dbo].[spTest] (@pVal1 INT = 0) AS BEGIN SET NOCOUNT ON; IF @pVal1 = 0 BEGIN SELECT 'two columns' AS COL1, 'COL2' AS COL2 END ELSE BEGIN SELECT 'one column only' AS COL1 END END But when i make the sp like this i can retrieve this ALTER PROCEDURE [dbo].[spTestOK] (@pVal1 INT = 0) AS BEGIN SET NOCOUNT ON; IF @pVal1 = 0 BEGIN SELECT 'two columns' AS COL1, 'COL2' AS COL2 END ELSE BEGIN SELECT 'one column only' AS COL1, 'COL2' AS COL2 END END Im using WD25 and SQL Native Driver30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68294-retrieve-mssql-stored-procedure/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)JOHNKENpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68294-retrieve-mssql-stored-procedure-68295/read.awp20 Feb 2021 08:56:22 ZWorking already, thanks.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68294-retrieve-mssql-stored-procedure-68295/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68294-retrieve-mssql-stored-procedure-68295/read.awpRetrieve MSSQL stored procedure