Select SUM Nvarchar

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (4)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Select SUM Nvarchar

thank's sir, I'm Try
Community Member Microsoft Employee on at

Like (0)

Report

RE: Select SUM Nvarchar

thank you sir, I understand, but this data has been used on some ax modules
Martin Dráb 230,214 Most Valuable Professional on at

Like (0)

Report

RE: Select SUM Nvarchar

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.
Suggested answer

Mea_ 60,278 on at

Like (0)

Report

RE: Select SUM Nvarchar

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.