Use

[Code]

Set NoCount ON

[/code]

at the beginning of the script. for good measure, turn it back off when done...

It looks like there is a mistaken assumption on the ability to reference the external query during a subquery. You can, using aliasing...

Select *, (Select Sum(OrderTotal) From Orders Where SalesmanID=S.SalesmanID)

From...