What's a good way to mask a consumerID?

• SQLSandwiches

  SSCrazy

  Points: 2143

  More actions

  September 1, 2010 at 10:14 am

  #227066

  Hi!

  I'm working with a database that has that stores information about consumers that are under our customers.

  So for example Customer 1234 has consumers 111,112,113, and 114 and Customer 1235 has consumers 115,116,117, and 118, and so on.

  This wasn't a problem but now our Product Owner doesn't want our customers to see how many consumers we have.

  What would be the best practice for masking these consumerIDs but still giving our an ID to our Customers?

  So we want to have Customer 1234 see their consumers as 1,2,3,4 but also have Customer 1235 see their see consumers as 1,2,3,4 or A1, A2, or whatever.

• tpaulsen

  SSC Enthusiast

  Points: 195

  More actions

  September 1, 2010 at 10:46 am

  #1215158

  Just use the "ROW_NUMBER() OVER" and partition by customer.