Pozdrav,

Na developer site-u
https://developer.datala...ls=pDE_SubjFinancialData
nalazi opis procedure pDE_SubjFinancialData i kako bi se trebala koristiti.

Partner je pokušao na taj način:
declare @a money
exec pDE_SubjFinancialData `Kupec d.o.o.`, `1200;1210`, `D`, @a, @a, @a, @a

ali dobiva se greška:

Msg 201, Level 16, State 4, Procedure pDE_SubjFinancialData, Line 0
Procedure or function `pDE_SubjFinancialData` expects parameter `@p_nInPeriod`, which was not supplied.

Zatim je pokušao na ovaj način:

declare @a money, @p_nInPeriod money, @p_nAll money, @p_nPaymentDue smalldatetime, @p_nInitialState varchar(20), @dDateGLStart smalldatetime

exec pDE_SubjFinancialData `dingo d.o.o.`, `1200;1210`, `D`, @p_nAll, @p_nInitialState output, @p_nInPeriod output, @p_nPaymentDue

select @a, @p_nInitialState, @p_nInPeriod

Ali dobiva se greška:

Msg 257, Level 16, State 3, Procedure pDE_SubjFinancialData, Line 0
Implicit conversion from data type smalldatetime to money is not allowed. Use the CONVERT function to run this query.
(1 row(s) affected)

Kako se može koristiti ova procedura?