title: How to store a list of items on a single column in SQL Server 2008
body: <p>I am looking for an efficient way to store users' information in a SQL Server 2008 table.</p>
  
  <p>In the design all users data will be stored in a series of columns in a single table but one of the columns requires to store a list of values, for example: <code>'column1'</code> will store the <code>username</code>, <code>'column2'</code> will store the <code>userID</code> and <code>'column3'</code> will store a list of items that will change over time. </p>
  
  <p>I want to avoid putting this information on a different table for each user because that would require a lot of tables in the database.</p>
  
  <p>What data type should I use for this <code>'column3'</code>? Should I use a completely different approach?</p>
  
  <p>I see that on SQL Server we can use the <a href="http://msdn.microsoft.com/en-us/library/ms175010.aspx" rel="nofollow">table data type</a>, but this seems to work only for temporary storage.</p>
  
  <p>Thank you.</p>