Vertical results from multiple columns

Question

Hello all,I am very new to SQL and I don't have so much experience. I am trying to help with a report and I am trying to gather results from 3 columns and stack it vertically. This is the query I have. I simplified it a bit for demo.&nbsp;&nbsp;Results&nbsp;What I am trying to get an output of something like this...Study IDB10Value&nbsp;&nbsp;&nbsp;Study1B10-1123Study1B10-2234Study1B10-3345Study2B25-1147&nbsp;If you guys can give me a hand I'd really appreciate it. I've been thinking of "Union", "Pivot" but I am not sure to how to apply for this scenario.Please help!&nbsp;Thank you all!

olafhelper · Answer

Binarak&nbsp;, I can't see anything in that screenshot in micro-format, but I guess you are looking for the UNPIVOT command, see&nbsp;Using PIVOT and UNPIVOT - SQL Server | Microsoft Docs&nbsp;For a more detailed answer please post table design as DDL, some sample data as DML statement and the expected result.&nbsp;Olaf

binarak · Answer

olafhelper&nbsp;Hello good sir. Thank you so much for taking time to respond. I thought that the screenshot might be too small. I wasn't sure how to give a clear view. Ill give you a better picture.&nbsp;Thank you so much.

ronen_ariely · Answer

Hi&nbsp;Binarak&nbsp;
&nbsp;
First, welcome to the family of SQL Server users&nbsp;
Even if the image is big and we can read the content, it is still an image and not queries - text which we can copy-&gt;test-&gt;fix...
&nbsp;
What do you think will be simpler and faster. Option one: each one of the 100 people that come to the forum to help others instead of helping 10 people, will spend all his time to manually check the image -&gt; type the query. Or maybe option two: one person who asked the question and has all the information will simply provide the query instead images?!?
&nbsp;
Please provide:&nbsp;
1) Queries to CREATE your table(s)2) Queries to INSERT sample data.3) The desired result given the sample.4) A short description of the business rules.5) Which version of SQL Server you are using.

binarak · Answer

Ronen_Ariely&nbsp;I apologize. I am very new to in depth SQL. I am a virtualization and Azure admin. Just trying to help with something I don't know. I know the difference between an image and text.I was just not sure how to post it in a presentable way, because when I copy and pasted, it looked like a disaster. I was probably over concerned about the look of my post. Is there a specific way to format the query or I just cope as plain text?

ronen_ariely · Answer

Hi&nbsp;Binarak&nbsp;
&nbsp;
As you probably noticed, I am not coming here every day so I might respond late. I am a lot more active in the Microsoft QnA forums where I also serve as Moderator like many others from the community&nbsp;
&nbsp;
&gt; I was just not sure how to post it in a presentable way, because when I copy and pasted, it looked like a disaster.
&nbsp;
As I wrote, you should provide queries and not spend time on formatting text in a way it presented in a client side.
&nbsp;
If you provide for example the queries:
CREATE TABLE RonenTbl (id int, txt NVARCHAR(100))
GO
INSERT RonenTbl (id, txt) values (1,'yes'), (2,'you'), (3,'can')
GO
&nbsp;Then no need for any work on presenting the content of the table since we can create the table in our server and insert the sample data
&nbsp;
This is what you need to provide! queries and not images&nbsp;
&nbsp;
1) Queries to CREATE your table(s)2) Queries to INSERT sample data.3) The desired result given the sample.4) A short description of the business rules.5) Which version of SQL Server you are using.

Forum Discussion

Vertical results from multiple columns

Share

Resources

Study ID	B10	Value

Study1	B10-1	123
Study1	B10-2	234
Study1	B10-3	345
Study2	B25-1	147