DECLARE @ParamDeff nvarchar(2000) SET @ParamDeff = '@Column2Get3Out char(20) OUTPUT, @Column2Get4Out char(20) OUTPUT' EXECUTE sp_executesql @sSQL, @ParamDeff, @Column2Get3Out =@Column2Get3 OUTPUT, @Column2Get4Out = @Column2Get4 OUTPUT