Read the table only once 😉

SELECT CAST( WorkDate AS datetime) + CAST(WorkTime AS datetime)
   + CASE WHEN Starttime > Endtime THEN 1 ELSE...

Why are we overcomplicating this?

SELECT left(datename(month,OrderDate),3)As Mnth, ID as ProductID,Project_No,OrderDate
FROM T2
order by month(OrderDate);

Is there a reason to use all those...

Complementing what Eirikur said, you should read this article: Creating a comma-separated list (SQL Spackle) - SQLServerCentral
Here's an example on what you're trying to achieve. Note that...

Did you try Lowell's suggestion?

You mention that you have 2 linked servers.
Where's newDB, myview and its underlying tables? Where are you running the code from?

Without more information, I can't be of much help.

Using Lowell's code, I just added logic to return only when the 1's are consecutive.

WITH MyCTE([Site],[MonthYr],[LongRun])
AS
(
  SELECT 'A',CONVERT(date,'Jan 1, 2016'),CONVERT(bit,'1') UNION ALL
 ...

This is one of the reasons I prefer to use cross tabs.

DECLARE @cols    AS NVARCHAR (MAX),
            @query AS NVARCHAR (MAX)
SELECT    @cols = STUFF((SELECT ',SUM( CASE WHEN...

I suggest that you post your data in a consumable format....