I have a program that populates data onto an excel sheet. I have the data in my SQL 2005 DB as a Numeric(8,2) datatype.
When I pull the data to populate the excel sheet, I want to either insert the number with a decimal or no decimal depending on the value.
So if the value is "4.00" I want to insert "4" to the excel sheet. If the value is "4.25" I want to insert "4.25" to the excel sheet.
How do i do that?