Member Avatar for GLT

Hi guys,

I have two tables one for that holds Customers details and one that holds Potential Customers details. The Potential Customer table is needed so the company can see who has enquired about the products but not bought them. I need to be able to automatically transfer details from the potential customers table to the customers table if/when they become customers.

I have given Customers a unique ID but how would I give potential customers a unique ID which then stays the same when it is tranfered to customers? would giving it an identity column change when I transfered to a table which also has an identity column?

Thanks guys!
(I do ask a lot of questions:P )

GLT

  • 2 Contributors
  • 1 Reply
  • 57 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by fatihpiristine
Member Avatar for fatihpiristine

possible with stored procedure with simple if else loop

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.