ALTER PROCEDURE [dbo].[SVC_Get_Tech_Work_Hours] (
    @TechID     CHAR(11),
    @InDate     DATETIME,
    @Avail      SMALLINT OUTPUT,
    @STARTTIME  DATETIME OUTPUT,
    @ENDTIME    DATETIME OUTPUT
)
AS
	DECLARE @Day SMALLINT 
	SELECT
		@Day = DATEPART(dw, @InDate)
	
	SELECT
		@Avail = CASE @Day
		              WHEN 2 THEN WORKDYS_1
		              WHEN 3 THEN WORKDYS_2
		              WHEN 4 THEN WORKDYS_3
		              WHEN 5 THEN WORKDYS_4
		              WHEN 6 THEN WORKDYS_5
		              WHEN 7 THEN WORKDYS_6
		              WHEN 1 THEN WORKDYS_7
		         END
	FROM
		SVC00100
	WHERE
		TECHID = @TechID
	
	IF @Avail <> 0
	BEGIN
	    SELECT
	    	@STARTTIME = CASE @Day
	    	                  WHEN 2 THEN WORKSTRT_1
	    	                  WHEN 3 THEN WORKSTRT_2
	    	                  WHEN 4 THEN WORKSTRT_3
	    	                  WHEN 5 THEN WORKSTRT_4
	    	                  WHEN 6 THEN WORKSTRT_5
	    	                  WHEN 7 THEN WORKSTRT_6
	    	                  WHEN 1 THEN WORKSTRT_7
	    	             END,
	    	@ENDTIME = CASE @Day
	    	                WHEN 2 THEN WORKEND_1
	    	                WHEN 3 THEN WORKEND_2
	    	                WHEN 4 THEN WORKEND_3
	    	                WHEN 5 THEN WORKEND_4
	    	                WHEN 6 THEN WORKEND_5
	    	                WHEN 7 THEN WORKEND_6
	    	                WHEN 1 THEN WORKEND_7
	    	           END
	    FROM
	    	SVC00100
	    WHERE
	    	TECHID = @TechID
	    
	    SELECT
	    	@STARTTIME = CONVERT(VARCHAR(20), @InDate, 102) + ' ' + CONVERT(VARCHAR(20), @STARTTIME, 108),
	    	@ENDTIME = CONVERT(VARCHAR(20), @InDate, 102) + ' ' + CONVERT(VARCHAR(20), @ENDTIME, 108)
	END
	ELSE
	    SELECT
	    	@STARTTIME = @InDate,
	    	@ENDTIME = @InDate
	
	RETURN (0)