Based on your description, the following may get you closer to where you need to be.

;WITH Dates AS (
/* Replace this with a calendar or tally table */ 
SELECT CAST(CAST(GETDATE() AS DATE) AS DATETIME) AS Date, DATEADD(DAY,(8*7)-1,CAST(GETDATE() AS DATE)) AS EndDate
UNION ALL
SELECT DATEADD(DAY,1,Date) AS Date, EndDate
  FROM Dates
WHERE EndDate > Date
), Teams AS (
SELECT 'B' AS TeamName, 0 AS Offset
UNION ALL
SELECT 'G' AS TeamName, 2 AS Offset
UNION ALL
SELECT 'R' AS TeamName, 4 AS Offset
UNION ALL
SELECT 'W' AS TeamName, 6 AS Offset
)

SELECT Date, MAX(BStart) AS BStart, MAX(BEnd) AS BEnd, MAX(GStart) AS GStart, MAX(GEnd) AS GEnd, MAX(RStart) AS RStart, MAX(REnd) AS REnd, MAX(WStart) AS WStart, MAX(WEnd) AS WEnd
  FROM (
        SELECT CAST(Date AS DATE) AS Date, CASE WHEN ((ROW_NUMBER() OVER (PARTITION BY TeamName ORDER BY Date)-1+Offset) % 8) BETWEEN 0 AND 1 THEN DATEADD(HOUR,9,Date)
                          WHEN ((ROW_NUMBER() OVER (PARTITION BY TeamName ORDER BY Date)-1+Offset) % 8) BETWEEN 2 AND 3 THEN DATEADD(HOUR,18,Date)
                          WHEN ((ROW_NUMBER() OVER (PARTITION BY TeamName ORDER BY Date)-1+Offset) % 8) BETWEEN 4 AND 7 THEN NULL
                      END AS ShiftStart,
                     CASE WHEN ((ROW_NUMBER() OVER (PARTITION BY TeamName ORDER BY Date)-1+Offset) % 8) BETWEEN 0 AND 1 THEN DATEADD(MILLISECOND,-3,DATEADD(HOUR,18,Date))
                          WHEN ((ROW_NUMBER() OVER (PARTITION BY TeamName ORDER BY Date)-1+Offset) % 8) BETWEEN 2 AND 3 THEN DATEADD(MILLISECOND,-3,DATEADD(HOUR,33,Date))
                          WHEN ((ROW_NUMBER() OVER (PARTITION BY TeamName ORDER BY Date)-1+Offset) % 8) BETWEEN 4 AND 7 THEN NULL
                      END AS ShiftEnd, TeamName + 'Start' AS TeamName1, TeamName + 'End' AS TeamName2                                                                                       
          FROM Dates
          CROSS APPLY Teams
       ) a
    PIVOT (
           MAX(ShiftStart) FOR TeamName1 IN ([BStart], [GStart], [RStart], [WStart])
          ) p1
    PIVOT (
           MAX(ShiftEnd) FOR TeamName2 IN ([BEnd], [GEnd], [REnd], [WEnd])
          ) p2
 GROUP BY Date;