that gets the data, but remember that this is coming from a temporary set of tables or database to a new final database.  He needs to populate the comments into...

I do follow ... now

I think i would create the initial table using the group-by logic...

then make a second pass for comments - which...

I'm not sure i fully follow, but it sounds like you wish to summarize order information, but include detailed comments, correct?

I agree with the previous post - a function to produce...

Well, Actually you can get input and output parameters using sp_executesql...

Note the @results parameter is returned just fine:

declare @results int
declare @sql nvarChar 

Update #tmp

Set ClaimNumber = c.ClaimNumber,LastName = c.LastName,FirstName = c.FirstName,LossDate = c.LossDate,InClaimFile = 1

From GE_Claim c Inner Join GE_Reserve r

On c.PolicyNumber = r.PolicyNumber And c.TableCode = r.TableCode And c.SeriesCode = r.SeriesCode

And...

set @FileExist = 'SELECT @Results=ColumnToCapture FROM OPENROWSET(BULK ''' + @File + ''' ,SINGLE_CLOB) AS Document'

I bet it would really help if you changed the UPDATE to an INSERT.

there are no rows in your temporary table...

Can  post when i have an issue with notepad?

(sorry - worked late, feeling rude today)