Store procedure with parameters

[sona_sa]

Hi,

I have a procedure with 5 parameters, Now I want to execute it in QlikView and want to Store all the records in QVD. I am using below the following script but it is giving error. So please 'let me know how it can be resolve.

Error is :

Script Which I am using in QlikView Script:

usp_EPCM_Get_MultipleSearch:

SQL EXECUTE [dbCertifiedInventory_Live].[dbo].[usp_EPCM_Get_MultipleSearch]

@LotID varchar(MAX)='262,260',

@FromDate varchar(150)='',               

@ToDate varchar(150)='',                            

@JewlexRapPriceDate datetime = '01-Apr-2014',

@GIARapPriceDate datetime = '01-Apr-2014';

Store usp_EPCM_Get_MultipleSearch into E:\Amit Kumar\EPCM\usp_EPCM_Get_MultipleSearch.Qvd;

Thanks

[sona_sa]

Hi Jonathan,

Thanks for reply.

Output is not coming.

But Same SP with same parameter it is giving 85 Rows in SQL.

Where I am wrong please let me know, It will very helpful for me.

Thanks

[sona_sa]

Any Update

[sona_sa]

Now the final SP Code with all the predefined parameters. Please check the code.

Is it correct or not ?

usp_EPCM_Get_MultipleSearch:

Load

[AvgClarity1_j],

[AvgClarity1_p],

[AvgClarity1_v],

[AvgClarity2_p],

[AvgClarity2_v],

[AvgClarity3_j],

[AvgClarity3_p],

[AvgClarity3_v],

[AvgColor_F],

[AvgColor_j],

[AvgColor_p],

[AvgColor_v],

[Certification_j],

[Certification_v],

[CertifiedPer],

[Clarity_P],

[Clarity1_j],

[Clarity1_v],

[Clarity2_j],

[Clarity2_P],

[Clarity2_v],

[Clarity3_j],

[Clarity3_P],

[Clarity3_v],

[Clarity4_j],

[Clarity4_P],

[Clarity4_v],

[Clarity5_j],

[Clarity5_P],

[Clarity5_v],

[ClarityAvg1_F],

[ClarityCode1_j],

[ClarityCode1_v],

[ClarityCode2_j],

[ClarityCode2_v],

[ClarityCode3_j],

[ClarityCode3_v],

[ClarityID1_j],

[ClarityID1_v],

[ClarityID2_j],

[ClarityID2_v],

[ClarityID3_j],

[ClarityID3_v],

[Color_j],

[Color_P],

[Color_v],

[Color1_j],

[Color1_v],

[Color2_j],

[Color2_P],

[Color2_v],

[Color3_P],

[Color4_j],

[Color4_P],

[Color4_v],

[Color5_j],

[Color5_P],

[Color5_v],

[ColorCode1_j],

[ColorCode1_v],

[ColorCode2_j],

[ColorCode2_v],

[ColorCode3_j],

[ColorCode3_v],

[ColorID_j],

[ColorID_v],

[Concatenate_j],

[Concatenate_v],

[CPF_P],

[CPF2_P],

[CPF3_p],

[CPS_j],

[CPS_v],

[cps1_j],

[cps1_v],

[cps2_j],

[cps2_v],

[cps3_j],

[cps3_v],

[CPS7_j],

[CPS7_v],

[CPS8_j],

[CPS8_v],

[Criteria_Mst_Count1_j],

[Criteria_Mst_Count1_v],

[Criteria_Mst_Count2_j],

[Criteria_Mst_Count2_v],

[Criteria_Mst_Count3_j],

[Criteria_Mst_Count3_v],

[Date_j],

[Date_v],

[Diff_perc],

[DiffHPtoActual],

[DollerIncentive_PenaltytoParty],

[EsRR],

[EstimatedLabourValue_j],

[EstimatedLabourValue_v],

[EstimatedRoughValue_j],

[EstimatedRoughValue_v],

[FinalColorCode1],

[FinalResultasPerJW],

[finaltotal],

[Fluorescence_j],

[Fluorescence_v],

[FluorescenceID1_j],

[FluorescenceID1_v],

[Galaxy_j],

[Galaxy_v],

[GD],

[HPEstPurity],

[HPTOFINAL],

[HPTOPARTY],

[ID_j],

[ID_v],

[Incentive_Penalty],

[IncentivePenaltyParty],

[Invoice$],

[jlxprice1_j],

[jlxprice1_v],

[jlxprice1Police_j],

[jlxprice1Police_v],

[jlxprice2_j],

[jlxprice2_v],

[jlxprice2Police_j],

[jlxprice2Police_v],

[jlxprice3_j],

[jlxprice3_v],

[jlxprice3Police_j],

[jlxprice3Police_v],

[Labour],

[LabourName_j],

[LabourName_v],

[Lot_v],

[LotDetailID_j],

[LotDetailID_v],

[LotID_j],

[LotID_v],

[LotNo],

[lotno_j],

[LotNo_P],

[lotno_v],

[Mix],

[OneExPer],

[PacketNo_j],

[PacketNo_P],

[PacketNo_v],

[PARTYTOFINAL],

[PolishCertWt],

[PolishNonCerWt],

[PolishWeight_P],

[PolishWeight1_j],

[PolishWeight1_v],

[PolishWeight2_j],

[PolishWeight2_P],

[PolishWeight2_v],

[PolishWeight3_j],

[PolishWeight3_P],

[PolishWeight3_v],

[PolishWeight4_j],

[PolishWeight4_v],

[PolishWeight5_j],

[PolishWeight5_P],

[PolishWeight5_v],

[PolishWeight6_P],

[RapPrice1_j],

[RapPrice1_v],

[RapPrice2_j],

[RapPrice2_v],

[RapPrice3_j],

[RapPrice3_v],

[Rate1_j],

[Rate1_v],

[Rate1Police_j],

[Rate2_j],

[Rate2_v],

[Rate2Police_j],

[Rate3_j],

[Rate3_v],

[Rate3Police_j],

[Rate7_j],

[Rate7_v],

[Rate8_j],

[Rate8_v],

[Rate9_P],

[Rate10_P],

[RoughRetWt],

[RoughWeight_j],

[RoughWeight_v],

[sarintotal],

[Shape_j],

[Shape_v],

[ShapeID_j],

[ShapeID_v],

[Size1_j],

[Size1_v],

[ThreeExPer],

[TotalJwelex],

[Totalpolise],

[TotalPolish],

[TotalVendor],

[TotalVendor_f],

[UploadType_j],

[UploadType_v],

[Value1_j],

[Value1_j_Polish],

[Value1_v],

[Value2_j],

[Value2_j_Polish],

[Value2_v],

[Value3_j],

[Value3_j_Polish],

[Value3_v],

[Value7_j],

[Value7_v],

[Value8_j],

[Value8_v],

[Value9_P],

[Value10_P],

[vendortotal],

[VG],

[VGXX];

SQL EXECUTE [dbCertifiedInventory_Live].[dbo].[usp_EPCM_Get_MultipleSearch]

@LotID = '262',

@FromDate = '',             

@ToDate = '',                         

@JewlexRapPriceDate = '01-Apr-2014',

@GIARapPriceDate = '29-Sep-2014';

If Alt(NoOfRows('usp_EPCM_Get_MultipleSearch'), 0) > 0 Then

Store usp_EPCM_Get_MultipleSearch into ...\usp_EPCM_Get_MultipleSearch.Qvd;

End If

Thanks

[Peter_Cammaert]

Could be access rights-related...

Is the user/password combination in the QlikView CONNECT string the same as the one you used in your SQL tests (that were producing 85 rows)?

[sona_sa]

yes oledb connection are good and test connection are fine