Avatar of Kinderly Wade
Kinderly Wade
Flag for United States of America asked on

MS query to obtain a single row of data with multile rows

Dear experts,

I would like to find out how can I modify my query to change the way my query result displays.

Here is my query:

SELECT product_id, warehouse_loc
FROM inventory
ORDER BY product_id

My display result will look like this:

product_id              warehouse_loc
NX-1233-01             B1-2
NX-1223-01             B2-2
Nx_1223-01             B3-1

Is there a way that I can modify my result to look like this:

product_id              warehouse_loc
NX-1233-01             B1-2
                                B2-2            
                                B3-1

Thanks
DatabasesMicrosoft SQL Server 2008SQL

Avatar of undefined
Last Comment
Jim Horn

8/22/2022 - Mon
Jim Horn

Not without a fair amount of pain.  It is the opinion of most developers that cosmetics like this are better served in whatever reporting application you are using as opposed to in T-SQL, as doing it that way in a set would hose up grouping/sorting.

For example, in SQL Server Reporting Services (SSRS) in the textbox for the product_id column the HideDuplicates property can be set to True, which would blank out all 'duplicates' beyond the first row.
ASKER CERTIFIED SOLUTION
Sean Stuber

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Najam Uddin

Do you want 3 rows with blank in 2 and 3rd row for first column?
Jim Dettman (EE MVE)

<<For example, in SSIS in the textbox for the product_id column the HideDuplicates property can be set to True, which would blank out all 'duplicates' beyond the first row.>>

 Same is true in the Access report writer, but not in a query.

Jim.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Jim Horn

typo correction, in my original comment I had SSIS instead of SQL Server Reporting Services (SSRS).   Corrected.