how to cast sum of an amount value

Posts   
 
    
PAZIMLI
User
Posts: 82
Joined: 01-May-2008
# Posted on: 08-Oct-2008 10:30:48   

Hi,

select item_kodu,round(sum(lot_miktar),2) from seri_no group by item_kodu order by sum(lot_miktar) desc

how can I write above sql statement with an llblgen.

I have a problem about round ??? how to cast ??

thanks.

PAZIMLI
User
Posts: 82
Joined: 01-May-2008
# Posted on: 14-Oct-2008 16:54:45   

Why nobody answers my question, isn't it clear enough?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39614
Joined: 17-Aug-2003
# Posted on: 14-Oct-2008 18:08:54   

Well, because you posted in general chat instead of a normal forum? General chat threads aren't added to our monitoring queues.

What have you tried yourself which doesn't work and which errors did you run into?

Frans Bouma | Lead developer LLBLGen Pro