title: Tally Table in SQL
body: <p>I want to create a bunch of data with Tally table in SQL (sql2008) and definitely need help.</p>
  
  <p>First of all, I have this table which contains 2 columns.</p>
  
  <pre><code>{
    AcctNum  (nchar(30), null),
    DataInfo (nchar(745), null)
  }
  </code></pre>
  
  <p>While I don't care the data in the DataInfo column, I do want to add about 10k of row into the table with unique AcctNum on each row. </p>
  
  <p>The problem though is I need to keep the length of the data in both column. For example, AcctNum column looks like "400000000000001               ". how do I increment the number while keep the "blank space"?</p>
  
  <p>Not sure if I make much sense here, but please let me know and I will try to explain more, thanks!</p>