title: Is it possible to create a Unique ID in an SQL Server View that will remain the same each time the view is called?
body: <p>I've got 10 tables that I'm joining together to create a view. I'm only selecting the ID from each table, but in the view, each ID can show more than once, however the combination of all ID's will always be unique. Is there a way to create another column in this view that will be a unique ID?</p>
  
  <p>I'd like to be able to store the unique ID and use it to query against the view in order to get all the other ID's.</p>