Select SUM Nvarchar

(0) Share

Report

Posted on by Community Member

Hello everyone!

I need your help..

I have a SUM select query but the data type is NVARCHAR. in mssql it is recommended to use CAST, what if on AX?

select TransId,PRODUCTID,Sum(Cast(Qty As Decimal(10,2))),Sum(Cast(QTYSCAN As Decimal(10,2)),TransType
from TempBarcode1
group by TempBarcode1.TransId,TempBarcode1.PRODUCTID,TempBarcode1.TransType
where TempBarcode1.TransType == 'PickingListRegistrasi' &&
TempBarcode1.TransID == SalesParmTable.SalesId

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

You cannot do this in AX, so either store it as a decimal or change it to while select and convert to real inside of the loop.

Was this reply helpful? Yes No
Martin Dráb 239,592 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

If you store Qty as string, the key problem in in your data model. You'll be able to query the data easily when you switch to the right data type.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

thank you sir, I understand, but this data has been used on some ax modules

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

thank's sir, I'm Try

Was this reply helpful? Yes No