数据格式问题?
有如下表:
ID FQty
A 1.00000

B 2.00000

A 3.30000


这是表的结构,不能改的,按ID汇总,
用一变量显示如下格式:

4.5+1


如:我是这样用的,但没有实现如上格式:
select @FNOte= '+ '+ltrim(sum(convert(dec(10,1),FQty))

stuff....


最终可以显示:4.5+1.0,那如何显示如上格式呢?

[解决办法]
select @FNOte= '+ '+ltrim(sum(convert(dec(10,0),FQty))
[解决办法]
刚才错了，不好意思i，这样应该对了
create table #temp
(ID varchar(10),
FQty decimal(10,5)
)
insert into #temp
select 'A ',1.00000 union all select 'B ',2.0000 union all select 'A ',3.30000
select * from #temp


select
case
when cast(FQty as decimal(10,1))-cast(FQty as decimal(10,0))=0.0
then cast(cast(FQty as decimal(10,0)) as varchar(50))
when cast(FQty as decimal(10,1))-cast(FQty as decimal(10,0)) <> 0.0
then cast(cast(FQty as decimal(10,1)) as varchar(50))
end
from
#temp

------------------

1
2
3.3