How to assign random values to each row in SQL for Acumatica

Hello everybody,

recently during testing of some logic for me it was necessary to assign some random values to table VendorPart in Acumatica. In order to achieve it, I've created such a script:

update VendorPart set NetPrice = (ABS(CHECKSUM(NEWID()))% 3000.25 + 1.1 + 1), ListPrice= (ABS(CHECKSUM(NEWID()))% 3000.25 + 1.1 + 1)
	where NetPrice = 0 and ListPrice = 0

of course such a query will not satisfy all requirements for random numbers generator, but in scope of my business scenario it was better then assign the same value to both columns.

Summary

If you want to have some diversity in digits for your values, use NEWID function for assigning values.

Add comment

Loading