Suggestions on T-SQL query

Asked Mar 25 '21 at 12:36

Active Mar 25 '21 at 12:36

Viewed 22 times

I am trying to work out a way to display all the data on the same row for each document number.

I have attached a screenshot of the table output. Basically the database presents the components of each product on separate lines, and I want to put them all onto one line.

Can anyone suggest a solution ?

select DOC_NUMBER , PRODUCT_CODE , MATL_1 , MATL_2 , MATL_3 , MATL_4 
from PRODUCT_STRUCTURE

Table

edited Mar 25 '21 at 12:36

Larnu

76,706
10
34
63

asked Mar 25 '21 at 12:36

Adrian Radu

Sample data and expected results, along with your attempts, will help us help you. – Larnu Mar 25 '21 at 12:37
`GROUP BY DOC_NUMBER` and `SELECT MAX()` for all other columns – HoneyBadger Mar 25 '21 at 12:40
See this answer: https://stackoverflow.com/a/2941248/1220550 – Peter B Mar 25 '21 at 12:42

Suggestions on T-SQL query

0 Answers0