Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a procedure and I want to pull the data with some input parameter. So Can you suggest me how I can do the same.
These are the following input parameters :
@LotID Bigint,
@FromDate varchar(50),
@ToDate varchar(50),
@Diff varchar(50),
@colours varchar(50) ,
@clarity varchar(50) ,
@JewlexRapPriceDate datetime ,
@GIARapPriceDate datetime,
@VendorDate datetime
Now How I will define this in QlikView and How I will fetch the data from SQL Database. My SP name is : [usp_EPCM_Get_FinalPolish_Report_bck]
Thanks Team.
See this post: Re: Store procedure with parameters
I tried the same but it is not providing me any single no. of rows. No any output.