如果是值varchar则求和 [英] Sum if is value varchar
本文介绍了如果是值varchar则求和的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
总和,如果是值varchar ...总和,iff为null为0
错误是
消息174,级别15,状态1,行1
替换函数需要3个参数。
消息156,等级15,状态1,行2
关键字'as'附近的语法不正确。
MS sql
我的尝试:
选择dobavljac作为'Dobavljac',SUM(isnull(cast(REPLACE(CONVERT(varchar,CONVERT(float,iznos_sa_pdv),1)),'#,0.00',''),0)AS UKUPNO)
from(select dobavljac,iznos_sa_pdv from ulazni_racun_roba_lista union all select poslovni_partner,iznos_sa_pdv from mp_ulazni_racun_ostalo_lista)as alltables
group by dobavljac
解决方案
< blockquote>检查你的SQL:
选择
SUM(
isnull(
cast(
REPLACE(
CONVERT ( varchar , CONVERT ( float ,iznos_sa_pdv), 1 )
* 1 ===> ),' #,0.00',' '), 0 ) AS UKUPNO)
见* 1 ===>,现在你应该很容易解决。
Sum if is value varchar...sum, iff is null to be 0
Error is
Msg 174, Level 15, State 1, Line 1 The replace function requires 3 argument(s). Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'as'.
MS sql
What I have tried:
select dobavljac as 'Dobavljac', SUM(isnull(cast(REPLACE(CONVERT(varchar,CONVERT(float,iznos_sa_pdv),1)), '#,0.00',''),0) AS UKUPNO) from (select dobavljac, iznos_sa_pdv from ulazni_racun_roba_lista union all select poslovni_partner, iznos_sa_pdv from mp_ulazni_racun_ostalo_lista) as alltables group by dobavljac
解决方案
Check your SQL:
select SUM( isnull( cast( REPLACE( CONVERT(varchar,CONVERT(float,iznos_sa_pdv),1) *1===> ), '#,0.00',''),0) AS UKUPNO)
See *1===>, now it should be easy for you to solve.
这篇关于如果是值varchar则求和的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文