Hi,
Can anybody tell me please what's wrong with my sql query? Here is the code:
ALTER procedure [dbo].[presmSal](@data DateTime,@saldo decimal)as
select sum(iznosden) as priem from blagajna_jspturswhere data=@data and vp>0 and vp<=10
select sum(iznosden) as isplata from blagajna_jspturswhere vp>10 and data=@data
update Kasovizvestaj
set saldo=@saldo + (priem) - (isplata) return
Thanks