Posted by SQL on 10/01/58 11:40

put convert(float,field) around your fields in the insert
example
declare @i int
select @i =1
select convert(float,@i),@i


http://sqlservercode.blogspot.com/

• Next in forum: Re: [SQL2000] permissions to use view based on tables from many databases
• Prev in forum: Re: [SQL2000] permissions to use view based on tables from many databases
• Thread view: Re: DTS Rounding problem

[Reply to this message]