Stored Procedures

Question

I have a stored procedure which needs to take the current year as input how do i achieve this?

I tried the following it works in SQL but it gives me an error in Alteryx

declare @dateToday int;
set @dateToday= Year(getDate())

exec source.procedure
@Year = @dateToday

geraldo · Accepted Answer

Hi

One suggestion is to use the dynamic imput tool. Make date change

create procedure new_proc ( @from_date smalldatetime )
as

SELECT * FROM TBL_SQLSERVER_EMITIDOS where cptdat = @from_date

Dynamic input configuration:

make sure you can

[]