iznos_sa_pdv ukupno 1 42.12 NULL 2 47,524.23 NULL 3 616.80 NULL
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
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)