Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Calling a stored procedure

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

2 Replies
adamdavi3s
Master
Master

Anonymous
Not applicable
Author

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

how should my execute statement look?