Select Code, Sum(Amt * Qty ) from Xyz
GROUP BY code
>Sele Code, Sum(Amt * Qty ) from Xyz into Cursor Cur1
>
>How will i convert this Sql Statement to Sql Server Commnad
>
>i Tried in this way that
>
>"Select Code, Sum({(Amt * Qty )}, Amount) from Xyz "
>But its giving error
>
--sb--