Store Procedure in qlik sence

[QlikLearner_2022]

Hi Team

I have a requirement where i need to use single line store Proc and create all the parameters in qlik sence

while i'm creating variables and trying to run report i'm getting error

could someone please help me in this regard

my Script;

LIB CONNECT TO 'Microsoft_SQL_Server';

Let vcUser ='user;
let vcArea ='AreaName';
Let Vstart='2022-01-01';
Let Vend='2024-12-12';

SQL;
execute dbo.uspGetProductName;

could someone guide me where i'm doing wrong, i'm getting error near SQL

[QlikLearner_2022]

@vinieme12 

I tried the script given by you

LIB CONNECT TO 'Microsoft_SQL_Server;

SQL
DECLARE @return_value int;

execute StarsReport.usp_StorePROC

@vcDOHUser = 'USER'
//,@return_value =
,@dtStart = '8/11/2019'
,@dtEnd = '9/15/2019'
,@vcArea = 'AreadID'
,@vcCounty = 'CountyID'
,@vcUser = 'UserName'
,@vcAgeGroupType = 'Regular'
,@vcAgeGroup = 'AgeGroupId'
,@vcDisease = 'DiseaseId'
,@vcProviderType = 'ProviderTypeId',
@vcPublicIndicator = 'Yes';

SELECT 'Return Value' = @return_value

!EXECUTE_NON_SELECT_QUERY;

exit script;

i'm getting error near SQL as below

[vinieme12]

remove semi colons ';'

LIB CONNECT TO 'Microsoft_SQL_Server;

LET vcDOHUser = 'USER';
//,LET return_value =
LET dtStart = '8/11/2019';
LET dtEnd = '9/15/2019';
LET vcArea = 'AreadID';
LET vcCounty = 'CountyID';
LET vcUser = 'UserName';
LET vcAgeGroupType = 'Regular';
LET vcAgeGroup = 'AgeGroupId';
LET vcDisease = 'DiseaseId';
LET vcProviderType = 'ProviderTypeId';
LET vcPublicIndicator = 'Yes';
LET return_value = ????;

SQL
DECLARE LET return_value int;

execute StarsReport.usp_StorePROC

$(vcDOHUser)
,$(dtStart)
,$(dtEnd)
,$(vcArea)
,$(vcCounty)
,$(vcUser)
,$(vcAgeGroupType)
,$(vcAgeGroup)
,$(vcDisease)
,$(vcProviderType)
,$(vcPublicIndicator)

!EXECUTE_NON_SELECT_QUERY;

[QlikLearner_2022]

@vinieme12 

Sorry i did not got your point

This is my script

LIB CONNECT TO 'Microsoft_SQL_Server;

SQL
DECLARE @return_value int;

execute StarsReport.usp_StorePROC

@vcDOHUser = 'USER'
//,@return_value =
,@dtStart = '8/11/2019'
,@dtEnd = '9/15/2019'
,@vcArea = 'AreadID'
,@vcCounty = 'CountyID'
,@vcUser = 'UserName'
,@vcAgeGroupType = 'Regular'
,@vcAgeGroup = 'AgeGroupId'
,@vcDisease = 'DiseaseId'
,@vcProviderType = 'ProviderTypeId',
@vcPublicIndicator = 'Yes';

SELECT 'Return Value' = @return_value

!EXECUTE_NON_SELECT_QUERY;

exit script;