By definition, a relationship connects two or more objects.  That means that you have to have at least one object on each side of the relationship, which means that you...

This only takes one scan of the table whereas the other two solutions require two.

;
WITH leaderboard AS
(
    select
        ROW_NUMBER() OVER (order by Value desc)...

Since a table represents a set, an empty table represents the empty set { }, so the value of any aggregate is either NULL or zero.

GROUP BY defines...

First, sample data should be provided as an INSERT statement into your sample table.

The solution below uses a tally table.  There is a blazing fast inline table-valued function...

If I understand what you want.  This will give it to you.

SELECT TOP 1 firstMonday
FROM
(
    VALUES
        (0, CAST(DATEADD(MONTH, DATEDIFF(MONTH, 6, GETDATE()), 6) AS DATE))
    ,    (1,...

Here is another solution.

SELECT ID,
(PATINDEX('%1%',(
    SELECT
        CAST([2017_07] AS BIT)
    ,    CAST([2017_06] AS BIT)
    ,    CAST([2017_05] AS BIT)
    ,    CAST([2017_04] AS BIT)
    ,    CAST([2017_03] AS BIT)
    ,    CAST([2017_02] AS BIT)
    ,    CAST([2017_01]...

If it's available, you can easily shred the XML query plan for the SQL statement to find any referenced tables.

Drew

Have you checked the end-of-record delimiter.  It could be LF, CR, or CR/LF.

Drew