Forum Discussion
Vertical results from multiple columns
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.
Thank you so much.
Hi Binarak
First, welcome to the family of SQL Server users
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->test->fix...
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 -> 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?!?
Please provide:
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.
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?
Hi Binarak
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
> I was just not sure how to post it in a presentable way, because when I copy and pasted, it looked like a disaster.
As I wrote, you should provide queries and not spend time on formatting text in a way it presented in a client side.
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') GOThen 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
This is what you need to provide! queries and not images
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.