Create ID Column in New Table

• mbrady5

  SSCrazy

  Points: 2835

  More actions

  July 3, 2012 at 7:01 am

  #260792

  Good morning, I would like to create a new table and use the combination of two of the columns to create the unique ID. Any suggestions on how to do that?

  Column 1(ID) = Column2 + Column3 ... That is the basic premise. Thanks

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  July 3, 2012 at 7:04 am

  #1508217

  Looks like you want to look at a computed column.

  http://msdn.microsoft.com/en-us/library/ms191250%28v=sql.105%29.aspx

• mbrady5

  SSCrazy

  Points: 2835

  More actions

  July 3, 2012 at 8:16 am

  #1508261

  Thanks, worked great!