T-SQL Add Row With Zeros When Data Does Not Exist
<p>I know this question has been answered a few times but I'm still having trouble adding an extra row while data doesn't exist until it does.</p>

<pre><code>DECLARE @Test TABLE 

(
ID NVARCHAR(10)
,Number INT

)
INSERT INTO @Test VALUES ('TG32',6)
INSERT INTO @Test VALUES ('TG32',6)
INSERT INTO @Test VALUES ('TG32',6)
INSERT INTO @Test VALUES ('TG32',2)
INSERT INTO @Test VALUES ('QD65',2)
INSERT INTO @Test VALUES ('QD65',3)
INSERT INTO @Test VALUES ('QD65',3)
INSERT INTO @Test VALUES ('HT76',7)
INSERT INTO @Test VALUES ('HT76',1)
INSERT INTO @Test VALUES ('HT76',5)

 SELECT CASE WHEN ID = 'TG32' THEN 'Hats'
            WHEN ID =  'QD65' THEN 'Coats'
            WHEN ID =  'HT76' THEN 'Shoes'
            WHEN ID =   'WR52' THEN 'Shirts' END
            , Number


 FROM @Test
</code></pre>

<p>I'm trying to get an extra row in the results that says Shirts   0  while there is no data for ID WR52 until there is?</p>

<p><a href="https://i.stack.imgur.com/osGXi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/osGXi.png" alt="enter image description here"></a></p>