Format Dataset with SELECT

Hi

Please could someone assist me with formatting my output data into the following dataset:

I have calculated two sets of variables i.e.

SET @vara_1 = <value>
SET @vara_2 = <value>

SET @varB_1 = <value>
SET @varB_2 = <value>

I now want to SELECT these so that the datset appears as follows

VARAVALUES   VARBVALUES
vara_1                 varB_1
vara_2                 varB_2


Thanks

I have selected two datsets
IlanOssinAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
SELECT @vara_1 VARAVALUES, @varb_1 VARBVALUES
UNION ALL
select @vara_2 VARAVALUES, @varb_2 VARBVALUES
0
 
IlanOssinAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.