Stored Procedure Dynamic Load

techvarun — Mon, 12 Aug 2013 09:04:19 GMT

I have a Stored Procedure called Sp_DataMaster with 3 Parameters

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

Re: Stored Procedure Dynamic Load

Mon, 12 Aug 2013 10:32:17 GMT

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