MERGE statement issue
<p>I have a table <code>[ExistingTable]</code> with three columns: <code>ID</code>, <code>Value</code> and <code>Date</code></p>

<pre><code>+----+------------------+
| ID | Value | Date     |
+----+------------------+
| 1  | 100   |2016-01-01|
| 1  | 200   |2016-01-01|
| 1  | 300   |2016-01-01|
| 2  | 200   |2016-01-01|
| 2  | 300   |2016-01-01|
+----+------------------+
</code></pre>

<p>and the second table, <code>[NewTable]</code></p>

<pre><code>+----+------------+
| ID | Value      |
+----+------------+
| 1  | 100        |
| 1  | 200        |
| 1  | 400        |
| 2  | 200        |
| 2  | 300        |
+----+------------+
</code></pre>

<p>If i write a merge statement like:</p>

<pre><code>MERGE [ExistingTable] AS T1
USING [NewTable] AS T2 ON (T1.[ID] = T2.[ID] AND T1.[Value] = T2.[Value])

WHEN NOT MATCHED THEN 
    INSERT([ID], [Value], [Date]) 
    VALUES(T2.[ID], T2.[Value], Getdate())

WHEN MATCHED THEN 
    UPDATE SET [Date] = Getdate();
</code></pre>

<p>The query will insert <code>ID = 1 AND Value = 400</code> and it will update dates for all the rest data.</p>

<p><strong>BUT</strong>, I want to make <code>INSERT</code> for all the <code>ID</code> field values, which has not been matched, in this example, I want to get this kind of result:</p>

<pre><code>+----+------------------+
| ID | Value | Date     |
+----+------------------+
| 1  | 100   |2016-01-01|
| 1  | 200   |2016-01-01|
| 1  | 300   |2016-01-01|
| 2  | 200   |2016-10-15|
| 2  | 300   |2016-10-15|
| 1  | 100   |2016-10-15|
| 1  | 200   |2016-10-15|
| 1  | 400   |2016-10-15|
+----+------------------+
</code></pre>

<p>Is it achievable with the <strong>MERGE</strong> statement?</p>