Hi, please I have a proc and it needs 2 parameters to return a result, I use this script to call this proc
LIB CONNECT TO 'Microsoft_SQL_Server_servidor';
[Data]:
SQL exec Prueba_1 @year = 2019, @var = 'A'
But I need use this parameters dynamically, and choose the year since other consult, for example
[years]:
LOAD
[year];
SELECT year,
FROM BDData.dbo."years";
How can I make this?