KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
In MS SQL, I need a approach to determine the largest scale being used by the rows for a certain decimal column. For example Col1 Decimal(19,8) has a scale of 8, but I need to know if all 8 are actually being used, or if only 5, 6, or 7 are being used. Sample Data: 123.12345000 321.43210000 5255.12340000 5244.12345000 For the data above, I'd need the query to either return 5, or 123.12345000 or 5244.12345000. I'm not concerned about performance, I'm sure a full table scan will be in order, I just need to run the query once.
Tags (comma-separated)
Save Edits
Cancel