topic Calling a stored procedure in QlikView

Calling a stored procedure

Anonymous — Wed, 21 Dec 2016 00:02:11 GMT

One of my developers sent me the following, how do I properly call this in the script editor?

DECLARE @organizationId uniqueidentifier, @resourceTypeId uniqueidentifier, @machineTypeId uniqueidentifier,

@startDate datetime, @endDate datetime

SET @organizationId = null

SET @resourceTypeId = null

SET @machineTypeId = null

SET @startDate = '2016-04-01'

SET @endDate = '2019-12-01'

exec spGetCapacityData @organizationId, @resourceTypeId, @machineTypeId, @startDate, @endDate

adamdavi3s — Fri, 23 Dec 2016 11:44:41 GMT

Anonymous — Fri, 23 Dec 2016 17:50:12 GMT

I get script line errors when I do the correct answer in that thread you linked to.

how should my execute statement look?