Return
-
Title
How to display one resultset per execution? -
Description
How to display multiple results from a stored procedure or multiple select statements into 1 resultset?
-
Resolution
WORKAROUND:
Use the operator UNION ALL in your code to display all results into resultset.
Example:
declare @a int
declare @b char(10)
declare @c char(20)
set @a=1
set @b='ddd'
set @c='dfdfdg'select '1', convert(char(10),@a)
union all
select '1', @b
union all
select '1', @c
STATUS:
An enhancement request has been submitted to be consider in a future version of Toad for Data Analysts. -
Defect ID
ST81315 -
Additional Information
Attached is what TDA will display in a future release.