Hi Experts,

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

Thanks in Advance
Abdulla