I am trying to run a stored procedure in a UCCX script, and then I want to use the response from the stored procedure in the UCCX script.
My Stored procedure looks something like :-
ALTER PROCEDURE Get_Date_Time @Status varchar(10) OUTPUT
AS
BEGIN
DECLARE @Today as date
SET @Today = GETDATE()
DECLARE @Now as time
SET @Now = CONVERT(TIME, GETDATE())
DECLARE @am_Start as varchar(50)
DECLARE @Lunch_Start as varchar(50)
DECLARE @pm_Start as varchar(50)
DECLARE @Eve_Start as varchar(50)
SELECT
@am_Start = AM_Start, @Lunch_Start = Lunch_Start, @pm_Start = PM_Start, @Eve_Start = Eve_Start
FROM
Special_Days
WHERE
Inst='Someone' AND Date=@Today
IF @Now<@AM_Start
SET @Status = 'Evening'
ELSE IF @Now<@Lunch_start
SET @Status = 'AM'
ELSE IF @Now<@PM_Start
SET @Status ='Lunchtime'
ELSE IF @Now<@Eve_Start
SET @Status ='PM'
ELSE
SET @Status ='None'
END;
In my UCCX Script, I have a DB Read step which does this :-
DECLARE @Status varchar(10)
EXEC Get_Date_Time
@Status = @Status OUTPUT;
SELECT @Status as N'Status'
If I click Test I get healthy looking integer 1 in the 'number of rows returned' box.
But how do I get access to the data that is returned? I have a string variable defined called Status but this just equates to an empty string after I run the script.
I don't get any errors when running, and it all validates ok.
So near, yet so far away!
Any help greatly appreciated.
