title: Creating view with an auto incremeting ID column in SQL Server 2008
body: <p>The view I am creating is loosing the Primary key of the main table as I use the aggregate function.</p>
  
  <p>But, I need one unique ID in my view to use it to create a dashboard. Can I create a dummy unique column with auto incremented value in SQL Server 2008?</p>