Composite Key - GUID and Int ID

• Andrew Westgarth

  Mr or Mrs. 500

  Points: 576

  More actions

  June 15, 2009 at 5:09 am

  #210553

  Hi,

  I have a situation where I have a table of users and each user can create one or more UserReport record. I have a UserReports table and would like to set a composite key of the foreign key of the UserID (GUID) from users table and a reportID of an integer incrementing with each report attributed to a user. i.e. User a report 1 user a report 2 user b report 1 user b report 2 etc

  I think my reasoning is right, struggling to get it set up properly in sql 2008 though. Wanted to check my theory behind it was correct first before referring this to a sql 2008 forum.

  Would somebody give me the benefit of their view on this please?

  Thanks

  Andrew

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  June 15, 2009 at 10:14 pm

  #1010008

  You haven't really given us nearly enough information to advise you.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]