Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Fitting > 9 values in DEC(1,0) column
Our solution was to store -3 for october (10), -2 for November (11) , and -1 for December (12). That made the presentation logic simply, IF negative value returned, ADD +13 to get correct result. Also our data conversion only affected 1/10 of the rows, and the code changes could be promoted... -
Fitting > 9 values in DEC(1,0) column
A previous design mistake had a column defined dec(1,0), which needs to contain the month of the year (1 = January to 12 = December). Obviously this works until we get to October (10). How can I easily fit 12 values into this column without redefining the column to 2 positions? Is there a...
