Member Avatar for GLT

Hi guys!

I was wondering if comeone could help me with transferring data from one table to another.

I am storing information of all customers who make an enquiry (PotentialCustomers) then transfering their details into a Customers table if they decide to purchase something from the company.

How would I go about keeping the ID from the PotentialCustomers table when the data is tranfered into the Customers table and ensuring that the ID is not the same as a different customer already in the Customers table?

I am aware of the keep identity check box and the Identity_insert statement but is there a way of ensuring that all the id's are different so when I do transfere there isnt two the same?

Thanks

GLT

  • 2 Contributors
  • 1 Reply
  • 69 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by Ramy Mahrous
Member Avatar for Ramy Mahrous

Make ID column Identity and incremented by one each time. you won't insert it by your hand and it kept unique.

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.