Question: I'm just trying to make a simple 600px wide line that scales responsively for e-amil, but I simply cannot make it display on Outlook 2013, Outlook 2016 on win 7 and Windows 10 E-mail.

The code looks like this, and the line I'm talking about is the line at the commentary "<--Horizontal line-->"

Right now i've made it an 600x1 PNG image, because it was even worse when I tried making it as an HTML line. Can anyone see what can cause this issue?

EDIT:
When I moved the HTML for the line out of the wrapping table, it worked.

Answer: 
Try the below script, using a recursive CTE here.

```
DECLARE @TABLE  TABLE
(
    Type1   NVARCHAR(10)
    ,Type2  NVARCHAR(10)
)   
INSERT INTO @TABLE
VALUES ('A','Dev'),('B','User'),('C','User1'),('User','Dev'),('User1','User'),('User2','User1')

;WITH CTE
AS
(   SELECT  Type1,Type2
    FROM    @TABLE
    UNION ALL
    SELECT  C.Type1, T.Type2
    FROM    CTE AS  C
        INNER JOIN  @TABLE  AS  T   ON  T.Type1 =   C.Type2
)
SELECT * FROM CTE
ORDER BY Type1,Type2 DESC

```

Output

```
Type1   Type2
A       Dev
B       User
B       Dev
C       User1
C       User
C       Dev
User    Dev
User1   User
User1   Dev
User2   User1
User2   User
User2   Dev

```
```
select t1.Type1 as X,
       t2.Type2 as Y
from table1 t1
join (select distinct Type2 from table1) t2
   on  t1.Type2 >= t2.Type2
order by x, y desc

```

Executes as:

```
SQL>select t1.Type1 as X,
SQL&       t2.Type2 as Y
SQL&from table1 t1
SQL&join (select distinct Type2 from table1) t2
SQL&   on  t1.Type2 >= t2.Type2
SQL&order by x, y desc;
X          Y
========== ==========
A          Dev
B          User
B          Dev
C          User1
C          User
C          Dev
User       Dev
User1      User
User1      Dev
User2      User1
User2      User
User2      Dev

                 12 rows found

```