By Michael Jackson on
7/19/2009 2:24 PM
In my day job I work for a manufacturer of custom kitchen cabinets. The machines that cut and form the materials operate as accurately as mere thousanths of an inch. Final dimensions and reports meant for human consumption usually require information in fractions of an inch. These dimensions are usually in 64ths, 32nds, 16ths, 8ths, 4ths, and halves of an inch. Dimensions are stored in the sql server database as decimal numbers that can be used for calculations. I felt that a SQL user defined function (udf) would be helpful in getting the information required for the reports. I set out to get that in place.
Read More »