Try this
DECLARE @empID UNIQUEIDENTIFIER
DECLARE @day DATETIME
SET @empID = @employee_id
SET @day = @date
SELECT
el.employee_id
, e.history_id
, CONVERT(VARCHAR(24),e.employee_timeIn,107) AS rawDate
, e.employee_workHours
, e.dayType
INTO #temp
FROM employee_list el
INNER JOIN employee_history e ON e.employee_id = el.employee_id
WHERE e.employee_id = @employee_id
AND CONVERT(VARCHAR(24),e.employee_timeIn,107) = @date
AND el.delete_status = 0
AND isActive = '1'
AND e.delete_status = 0
ORDER BY e.employee_timeIn ASC
IF @@ROWCOUNT = 0
BEGIN
INSERT INTO #temp
(
employee_id
, history_id
, rawDate
, employee_workHours
, dayType
)
VALUES
(
@empID
, '00000000-0000-0000-0000-000000000000'
, @day
, ''
, ''
)
END
SELECT * FROM #temp