2 Replies Latest reply: Dec 23, 2016 12:50 PM by P R RSS

    Calling a stored procedure

    P R

      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