Ok, I'm trying to write a query in a stored procedure in SQL Server 2000 ... certain situations I construct a string that contains the query and then use the exec() function to execute the ...

When selecting the data, I was expecting the zero values to be returned as 0.00 or 0, but they were returning as .00.<BR>So, I changed some fields to numeric(8,2), hoping that would help. Same ...