cstrabley Conceptually, this process is a perfect fit. In practice, everything appears to be working except for the last step. The 'DataMirror' is stuck in restoring mode. ...

Sergiy:

This is not correct due to the aggregate function...here's what the server says with your code:

Server: Msg 157, Level 15, State 1, Line 3

An aggregate may not appear in the...

Awesome. Thanks again!

Cheers!

B

Scorp,

I think I got it!

UPDATE OrdMain

SET

ListTotal = A.SumOfListItem

FROM

(SELECT Order_ID,SUM(ListEach) AS SumOfListItem

FROM OrdItem

GROUP BY Order_ID)

AS A

WHERE OrdMain.Order_ID = A.Order_ID

AND OrdMain.Order_Num = N'11589'

I was missing the Group By and...

Scorpion,

Thank you very much for the assistance. Sorry for the crappy code there...here is some corrections and cleanup...but it still gives errors:

When I run this in Query Analyzer

UPDATE OrdMain

SET

ListTotal =...