Click here to Skip to main content
15,891,529 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
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
Posted
Updated 30-Apr-18 10:40am
v3

1 solution

select datum, SUM (Try_Convert(float,[iznos_sa_pdv])) as UKUPNO
from mp_kasa_lista
group by datum
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900