Would something like this work?

DECLARE @DescriptionList varchar(max)

--Create temp table

CREATE #TempTable (

part varchar(6),

line int,

description varchar(50)

)

INSERT INTO @TempTable(part, line, description)

(SELECT part, line, description

FROM Table1

UNION

SELECT part, 1, description

FROM Table2

UNION

SELECT part, 1, extradescription

FROM...

Sorry, here is sample data:

Description Dose ...

This is an Oracle 9i database.

The patient data is in one table and the comments are in another with a one to many relationship (joined by a textid in each...