This is exactly my problem - I am building a "MASTER LOOKUP TABLE", the only columns in this table are (SEQUENCE_ID), (NEW_CUSTOMER_I D), and (OLD_CUSTOMER_I D).
Once the M table is ready, the NEW_CUSTOMER_ID will be the primary key, the application can use this table to track the business activities done under the (old customer id).
We have about 8000 customers.
TIA...
mimime
Last Activity: Dec 29 '09, 10:37 AM
Joined: Sep 21 '07
Location:
-
How to update column with data from other tables?
Scenario:
Assign a new_customer_id to each existing customer of our three business. A master lookup table (M) was given to me with pre-populated (SEQ_NOs), (NEW_CUSTIDs), and NULL in (OLD_CUSTIDS). My duty is to
(1) Fill the M.OLD_CUSTID column with existing customer ids from T1, T2, T3 (uniquely).
(2) Once the master lookup table is filled, add (SEQ_NO), and (NEW_CUSTID) column to the 3 existing customer tables to hold... -
THANK YOU ALL to help me out.Leave a comment:
-
Thank you.
Our PCs all came with "gold build" images, so MS office were pre-installed. The Admin rights are usually requested by developers. Some are necessary, some requests are strange (such as "need to sync up with my PDA").
I'd like to know if .NET? eclipse? weblogic? wesphere? or any other developer's tools have to have admin rights to install/run?
TIALeave a comment:
-
what MS application requires the admin right to install and to run?
I am new in this forum, please forgive me if this question has been discussed before.
I am an UNIX admin, our PC admin just quit so boss put me in charge of "granting the admin rights to the PC users". I was told that our policy is just say "NO", if the developers really need it, they will be back to fight for it. Only then we can consider the case. However, I was the programmer once and knew the pain of not having...
No activity results to display
Leave a comment: