Combining like info into one line.
Is this possible?
Combining 2 lines of text on one line.
I have order information that I am dumping to a dataloader. I would like to have the labor combined and then one of the products added to the line as well. If there are multiple lines of products I want them on seperate lines.
So it would go like this.
Labor 5
Labor 4
labor 9
then product one 5
labor 9 product one 5
then product 2 – 6
Product 2 3
Product 3 5
Product 4 15
Product 5 3
Product 6 4
output to look like this.
labor 9 product one 5
Product 2 3
Product 3 5
Product 4 15
Product 5 3
Product 6 4
I am struggling with getting this started in PL/SQL. I can not see anyway to do this in SQL.
to further clarify.
I have service contract and order information that I combine to do an upload into an other system.
The data comes out as follows
for each line on the service request I get one line from the order.
Standard.
I would like to get the service line and the first part line to combine into one line.
If possible I would also like the service lines to combine if there are more than one.
Also if there are more than one part number lines. I would like them to remain as seperate lines without service information.
When I do the upload.
I need Service and the first product on one line and all other parts on that order to go to the bottom of the report.
Thank you for your help in advance I am new to all this,
Steven Pelletier