topic SQL Stored Procedure - How to call current date parameter in QlikView

SQL Stored Procedure - How to call current date parameter

stevegimbrollmt — Mon, 26 Nov 2012 14:51:10 GMT

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

Mon, 26 Nov 2012 14:59:22 GMT

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

stevegimbrollmt — Mon, 26 Nov 2012 15:43:27 GMT

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)';