•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 456,580 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,616 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 837 | Replies: 1
 |
•
•
Join Date: Aug 2007
Posts: 98
Reputation: 
Rep Power: 2
Solved Threads: 0
Junior Poster in Training
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
)
GLT
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
)GLT
|
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- IDENTITY question (MS SQL)
- Identity Column Problem in MS SQL Server when moving data from using Bulk Copy (MS SQL)
- Identity Column Problem in MS SQL Server (MS SQL)
- select rows divisible by 5 (MS SQL)
- Retaining values across pages in ASP.Net (ASP.NET)
- want to write latin translator what language should i choose (Computer Science and Software Design)
Other Threads in the MS SQL Forum
- Previous Thread: Get data out of excel file stored as an image
- Next Thread: How to multiply field by -1 under certain circumstances
