Fetch the data from SP to QlikView with input parameter.

[sona_sa]

Hello Team,

I have a Store Procedure with 5 Input parameters. Now I want to fetch the data for with same input parameter and that data I want to save in QVD. How we can to the same.

SP NAME : usp_EPCM_Get_FinalPolish_Report_bck

Input Parameter :

@LotID Bigint,

@FromDate varchar(50),

@ToDate varchar(50),

@Diff varchar(50),

@colours varchar(50) ,

@clarity varchar(50) ,

@JewlexRapPriceDate datetime ,

@GIARapPriceDate datetime,

@VendorDate datetime

Please suggest me how we can do the same. I have tried from my end so many time but I could not able to fecth the data and can not store into QVD.

Thanks.

[vinay_hg]

when u are loading thourgh variable pass the parameter, i mean creat 5 variable save the input values pass the same to the procedure.