Hi,



Just noticed a problem with decimals during data deployment. I have a simple VERSION table defined as follows:-



Field Name Field Type

NAME VarChar(40) - primary key

VALUE Decimal(10,2)



I have created a data deployment package set to overwrite and have noticed that the deployment stored procedure which is created doesn't support decimal places in the VALUE field. The stored procedure definition is:-



CREATE PROCEDURE VERSIONInsertOverwrite @NAME as VarChar(40), @VALUE as Decimal AS BEGIN DELETE FROM VERSION WHERE NAME = @NAME INSERT INTO VERSION (NAME, VALUE) VALUES (@NAME, @VALUE) END



When the procedure is executed as follows, it drops the decimal places:-



exec VERSIONInsertOverwrite @NAME='Database',@VALUE=10.01



The above code stores a value of 10 instead of 10.01



Just to confirm, the VALUE field is definitely defined as 10.2 and can store a value of 10.01 through an update statement.



Aaron

I will set this up and see if I can reproduce.  Thanks.