Database

Alex Lush wrote:

Any help or pointers on where to start looking greatly apreciated.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

SELECT order_no, order_line_no, line_type, product, long_description + ' ' + (SELECT B.long_description FROM Table1 B WHERE B.line_type = 'C' AND A.order_no = B.order_no AND A.product = B.product) AS long_description
FROM Table1 A
WHERE line_type = 'P'

create table #t2
(
    order_no          varchar(255),
    order_line_no     int,
    long_description  varchar(8000),
    done              bit
)
 
Insert	Into #t2 (order_no, order_line_no, long_description, done)
Select  order_no, 
        order_line_no, 
        long_description,
        0
From    #t1
Where   line_type = 'p'
 
Declare @i int
Set @i = 1
 
While (Select count(*) From #t2 where Done = 0) > 1
Begin
 
    Update  t2
    Set     t2.long_description = t2.long_description + ' ' + t1.long_description
    From    #t1 t1
    inner join
            #t2 t2
    On      t1.order_no = t2.order_no
    And     t1.order_line_no = t2.order_line_no + @i
    And     t1.line_type <> 'P'
    And     t2.done = 0
    
    
    Update  t2
    Set     t2.done = 1
    From    #t1 t1
    inner join
            #t2 t2
    On      t1.order_no = t2.order_no
    And     t1.order_line_no = t2.order_line_no + @i
    And     t1.line_type = 'P'
 
Set @i = @i + 1
 
End