Stored Procedure Dynamic Load

[techvarun]

I have a Stored Procedure called Sp_DataMaster with 3 Parameters 

1.StartDate

2.EndDate

3.ProjectName

is there any possiblities to run the stored procedures with front end values

Eg: I have 2 datepickers and a DropDown for the above  3 parameters and Do the Partial Load?

Thanks in Advance

[#2 · Accepted solution]

Hello,

This possible. You have to make sure that the variables in QV have the same format as the variables in your stored procedure.

You also have to make sure that the front end variables are not overwritten by the script (variables).

For example:

Load *

;

sql execute a.dbo.stored_procedure $(vStartDate), $(vEndDate), $(vProjectName);

Hope this helps.

gr.

Frank