I'm not sure what you mean by "strip line".   Also, the word "variance" isn't defined in your post, so I have to guess as to what you're referring to, as...

Also, I don't know for sure exactly what needs to be pivoted.   Just joining the pivot query to the other tables may not work quite the way you want, and...

If you're going to perform this function on a regular basis, then you need to have an initial run that will likely be different than the ongoing runs.   As an...

Does mySql have an ODBC driver?  If so, you could create a "Linked Server" for when you want to access the data directly from SQL Server.   Once you have that...

Probability is rather dependent on how you choose to perceive it.   On small data samples, the likelihood of that probability being accurate is rather low.   You usually need to measure...

CONVERT the date field to varchar() for display purposes as part of the query.

If you are going to have a stored procedure return multiple values, why on earth go to the trouble of using output parameters when a single row returned as a...

Here you go:
CREATE TABLE dbo.TimeTable (
    WorkDate date,
    EmpID int,
    EmployeeName Varchar(20),
    Code Varchar(20),
    Starttime time,
    Endtime time
);
INSERT INTO TimeTable (WorkDate, EmpID, EmployeeName, Code, Starttime, Endtime)
    VALUES    ('6/19/2017',...