With the changes above it does work just fine without the loop.

The whole code is below, with the xp_sendmail part as well if anyone else is looking to send results...

Yep, that's it. The WHERE SLPRSNID =@MinRep is used for looping. The section above the whole thing changes @MinRep so that the loop selects the next record.

I'll give...

Sorry for the confusion. @Message does change, basically it grows, adding the results from the previous record, until there are no records left in @Stage table (from @MinRep to...

It works fine with the SELECT @Message = ISNULL(@Message + ',', '') + @Concat replacement, but I can't get it working with Sergiy's solution.

It's probably just the way that I...

Wow, thanks for the fast response!

Stepped out for an hour and I've come back to not only the solution but an improvement on the design.

For future reference, I understand the...

Regestering the 2 dlls fixes the problem.  No need to re-apply the service pack.

Thanks Nicholas!

Thanks,

Learn something new everyday.

Regards,

Mark

Scott,

Not that it is an issue here, as the query runs in the blink of an eye, but wouldn't a subquery run more slowly as it has to complete both...

I thought there might be a way to reference expression columns.  MS-Access can do it, and there's usualy a way to do it in sql if access can.

AGS I like...

Select

(a.qty1*price1) as total1,

(a.qty2*price2) as total2,

(total1 + total2) as Gtotal

from a

Obviously I could do '((a.qty1*price1)  + (a.qty2*price2)) as Gtotal' would work, but there must be a simpler way to do it.

Thanks,

Mark

Phil,

Thanks for the reply.

I'm not completely skilled with VBScript, but I think I could figure it out.

I'd still like, if possible, to create a DTS package because of the logging...

Did a little further diggin on this site and http://www.sqldts.com and came up with a solution:

'**********************************************************************

'  Visual Basic ActiveX Script

'************************************************************************

Function Main()

 Dim Doc

 Dim LoopCheck

 Set LoopCheck = DTSGlobalVariables.Parent.Steps("DTSStep_DTSActiveScriptTask_1")

 Doc = DTSGlobalVariables("Document").Value

 If Doc <> ""...

Bruce, I'm not sure I understand your reply.

I have access to the package designer, it's how I created the package.

The package will be running on a schedule, I just want...