Saldo kupca na ispisu fakture

1. Ispod prikazanu skriptu pokrenite na pantheon bazi i na ispisu funkcijom sqlexp dodajte na ispis

Create function [dbo].[_vrniSaldo] (@acKey char (13))
returns char (255)
as
begin
declare @c char (255),
@d datetime,
@s char (30),
@n decimal (18,2)

set @d = (select adDate from tHE_Move where acKey = @acKey)
set @s = (select acReceiver from tHE_Move where acKey = @acKey)

set @n = (select sum(anDebit)-sum(anCredit)
from tHE_AcctTransItem
where adDateDoc between '2018-01-01' and @d
and acAcct like '211%' and acSubject = @s)

if @n is null
begin
set @n = 0
end

set @c = rtrim(replace(str(@n,30,2), ' ', ''))

set @c = 'Saldo dugovanja na dan ' + LEFT(CONVERT(VARCHAR, @d, 104), 10) + ' iznosi: ' + rtrim(@c) + ' KM'

return @c

end