Post reply

sql 2005 - Rewite Update Statement

  • October 9, 2008 at 3:57 am

    #382995

    How do I rewrite this update statement..

    UPDATE dbo.Comm

    SET SumOfBalance = Bal.SumofBalance

    FROM dbo.Comm a

    INNER JOIN

    (

    SELECT

    ClientNo,SUM(Balance) AS SumOfBalance

    FROM

    ELLD.dbo.data

    GROUP BY Clientno

    )

    AS Bal ON a.clientno = bal.Clientno

  • October 9, 2008 at 4:52 am

    #882794

    Why do you want to rewrite it?

    Is it slow?

    Doesn't it work?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply