Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anyone help me with this please?
I have had a look at this discussion at Call a function in SQL LOAD but still don't understand.
I would like to use an example so if I have a SQL function called v_PNL, how can I load the data into Sense? What is the script in Sense data load editor?
v_PNL (@nmonth int, @year int, @lastYear int)
SELECT * from v_PNL (11, 2017, 2016)
Thank you very much!
Cheers
Fei
My colleague has figured it out.
The script should be:
SQL Select * from Databasename.dbo.FunctionName (variable1, variable2);
My colleague has figured it out.
The script should be:
SQL Select * from Databasename.dbo.FunctionName (variable1, variable2);
Hi All,
I successfully executed the script but it returned no results.
Please help. Thanks.
Func: Load *; SQL select * from DatabaseName.dbo.Report_ShipmentProfileReport (null,null ,null,null,null,null,null,null,null,null,null,null,null,'2018-05-04','2018-05-31') ;
Hello Everyone,
Any help on this?
Thanks.