title: Create Computed Column using data from another table
body: <p>I have a SQL Server 2008 R2 database. This database has two tables called Pictures and PictureUse.</p>
  
  <p>Picture table has the following columns:</p>
  
  <pre><code>Id (int)   
  PictureName (nvarchar(max)) 
  CreateDate (datetime )  
  </code></pre>
  
  <p>PictureUse table has the following columns :</p>
  
  <pre><code>Id (int) 
  Pictureid (int) 
  CreateDate (datetime )  
  </code></pre>
  
  <p>I need to create a computed column in the <code>Picture</code> table which tells me that how many times this picture has been clicked.any help ?</p>