Forum Discussion

ChuckAtIvory's avatar
ChuckAtIvory
Contributor
15 years ago

Table Checkpoint - How to ignore numeric differences past the 10th decimal place

Hi there, A table in our application stores numbers out to as far as 20 decimal places. (Under the hood it needs to.) Sometimes there are numeric differences 10+ decimal places out. I want Test...
AlexKaras's avatar
AlexKaras
Champion Level 3
15 years ago
Hi Chuck,



Meanwhile as a workaround and depending on the database server you are using, you may consider creation of the helper stored procedure (SP) that will wrap your actual SQL statement and return data formatted with the precision that you need. Then you may save the initial SP output as a checkpoint and use it for the test.