SUM COLUMN varchar ... convert ... cast? [英] SUM COLUMN varchar...convert...cast?
本文介绍了SUM COLUMN varchar ... convert ... cast?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我试试......但我只有一天的结果记录...一个日期的3条记录......第一天...我需要从一天开始总结所有记录...
我的代码的结果是:
iznos_sa_pdv ukupno
1 42.12 NULL
2 47,524.23 NULL
3 616.80 NULL
我需要按日期记录总和....我的结果是今天的3条记录
我尝试过:
选择[iznos_sa_pdv] ,sum(cast(Try_convert(int,[iznos_sa_pdv])AS decimal))来自mp_kasa_lista的AS ukupno
WHERE [datum]> = CONVERT(datetime,convert(varchar(10),GETDATE() ,120),120)
AND datum< DATEADD(day,1,convert(datetime,convert(varchar(10),getdate(),120),120))
group by iznos_sa_pdv
解决方案
选择基准,SUM(Try_Convert(float,[iznos_sa_pdv]))作为UKUPNO
来自mp_kasa_lista
group by datum
I try...but I just have result records for one day...3 records for one date...lst date...I need sum all records from one day...
result of my code is:
iznos_sa_pdv ukupno
1 42.12 NULL
2 47,524.23 NULL
3 616.80 NULL
I need sum records by date....my result is 3 records for today day
What I have tried:
select [iznos_sa_pdv], sum(cast(Try_convert(int,[iznos_sa_pdv])AS decimal)) AS ukupno from mp_kasa_lista WHERE [datum] >= CONVERT(datetime, convert(varchar(10), GETDATE() ,120), 120) AND datum < DATEADD(day, 1, convert(datetime, convert(varchar(10), getdate(), 120), 120)) group by iznos_sa_pdv
解决方案
select datum, SUM (Try_Convert(float,[iznos_sa_pdv])) as UKUPNO from mp_kasa_lista group by datum
这篇关于SUM COLUMN varchar ... convert ... cast?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文