title: How do I create a wide table in SQL server 2016?
body: <p>With this code(*), the creation of a wide table in SQL keeps me sending this:</p>
  
  <pre><code>Msg 1702, Level 16, State 1, Line 11
  CREATE TABLE failed because column '2010/12/01' in table 'PriceToBookFinalI' exceeds the maximum of 1024 columns.
  </code></pre>
  
  <p>USE [Style]
  GO</p>
  
  <pre><code>CREATE TABLE [dbo].[PriceToBookFinalI]
      (DocID int PRIMARY KEY,
      [2006/12/29][Money],
      [2007/01/01][Money],
      ...
      SpecialPurposeColumns XML COLUMN_SET FOR ALL_SPARSE_COLUMNS);  
  
  GO
  
  (2614 columns)
  </code></pre>
  
  <p>Looking for a good hint !</p>
  
  <p><a href="https://i.stack.imgur.com/hhDn6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hhDn6.png" alt="Background of why I need a wide table"></a></p>
  
  <p>Here is the background set of data I want to import to my wide table </p>