Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
I have a stored proc which I want to run for 2 specific dates... which date is a parameter.
currently im doing something like
Let date = today();
Let prevDate = AddMonths(Today(),-1);
Pendinginv:
LOAD *;SQL EXEC (DWH.dbo.gb_FI_CustomersStarRating $('date'));
for some reason it is not executing it...it just jumps it.
Help will be appriciated
Steve
Hello Steve,
I think you will need to remove the ' from round the variable. This is an example of a stored procedure call we use :
letThisYear=Year(today());
load*;
sql exec dbo.usp_gls215_build_report_v2 $(ThisYear)
Good luck
John
Very kind and helpful
Actually here is what I did and it worked!
Let Date = date(today(),'yyyy/MM/dd');
Let prevDate = date(AddMonths(Today(),-1),'yyyy/MM/dd');
Pendinginv:
LOAD *;SQL EXEC DWH.dbo.gb_FI_CustomersStarRating '$(Date)';