Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 1.02 » View Incident Report |
Serious |
Reported By: Ole Willy Tuv Reported On: 4/8/2007 For: Version 1.02 Build 1 |
select floor((PV.rowID-1)/3)+1 as rowCellID, floor((PV.columnID-1)/3)+1 as columnCellID, PV.cellValue, count(*) as occurrences from PossibleValuesStage2 as PV group by floor((PV.rowID-1)/3)+1, floor((PV.columnID-1)/3)+1, PV.cellValue order by rowCellID, columnCellID, cellValue Workaround: select floor((PV.rowID-1)/3)+1 as rowCellID, floor((PV.columnID-1)/3)+1 as columnCellID, PV.cellValue, count(*) as occurrences from PossibleValuesStage2 as PV group by rowCellID, columnCellID, cellValue order by rowCellID, columnCellID, cellValue
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |