Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?