As soon as I sell my house in the Detroit area (worth 40% of the value 48 months ago), I'm on my way to Pittsburgh.... I'm hoping that companies in Pittsburgh understand that if you move all of your supplier contracts to China that there will be no one left to purchase your 50K SUV's.
Funny how the majority of American corporate decisions are made short term to maximize 'stock options' with no thought to what's right for the customer or employee's. Long term planning is a SEP. It's a concept from the Hitchhikers Guide to the Galaxy a (SEP) Someone Else's Problem - You can sometimes peripherally see it, but never get a good look at it and don't care if it doesn't effect you. Listing from sattached table. Table: CLLI No Lock(s) Descr: Server table - CLLI Amer 8.0 No. Column Name Attributes --- ------------------ ------------------------------------------------------ 1 STATE Type : TEXT 2 QualKey 2 NPA Type : INTEGER QualKey 3 NXX Type : INTEGER QualKey 4 LINE_RG Type : TEXT 17 QualKey 5 POOLED Type : TEXT 9 QualKey 6 PORTED_IN Type : TEXT 17 QualKey 7 LINE_RG_EX Type : TEXT 25 QualKey 8 EFF_DATE Type : DATE QualKey 9 STATUS1 Type : TEXT 12 QualKey 10 USAGE Type : TEXT 9 QualKey 11 RATE_DIST Type : TEXT 25 QualKey 12 RATE_CENT Type : TEXT 21 QualKey 13 SAG_NPA Type : DOUBLE QualKey No. Column Name Attributes --- ------------------ ------------------------------------------------------ 14 SAG_EXC Type : TEXT 16 QualKey 15 SAG_CO Type : TEXT 9 QualKey 16 CLLI Type : TEXT 16 QualKey 17 ENG_NAME Type : TEXT 35 QualKey 18 EXC_KEY Type : DOUBLE QualKey 19 HOST_CLLI Type : TEXT 15 QualKey 20 TAND_CLLI Type : TEXT 14 QualKey 21 CLLI_STATU Type : TEXT 13 QualKey 22 NET_FUNCT Type : TEXT 29 QualKey 23 SWITCH_TYP Type : TEXT 15 QualKey 24 BU_SWITCH_ Type : TEXT 17 QualKey 25 LATA_NAME Type : TEXT 26 QualKey 26 LATA_NUMBE Type : DOUBLE QualKey Current number of rows: SERVER Listing from same table in local DB (Source) Table: CLLI No Lock(s) Descr: SBC CLLI Information No. Column Name Attributes --- ------------------ ------------------------------------------------------ 1 STATE Type : TEXT 2 2 NPA Type : INTEGER 3 NXX Type : INTEGER 4 LINE_RG Type : TEXT 17 5 POOLED Type : TEXT 9 6 PORTED_IN Type : TEXT 17 7 LINE_RG_EX Type : TEXT 25 8 EFF_DATE Type : DATE 9 STATUS1 Type : TEXT 12 10 USAGE Type : TEXT 9 11 RATE_DIST Type : TEXT 25 12 RATE_CENT Type : TEXT 21 13 SAG_NPA Type : DOUBLE No. Column Name Attributes --- ------------------ ------------------------------------------------------ 14 SAG_EXC Type : TEXT 16 15 SAG_CO Type : TEXT 9 16 CLLI Type : TEXT 16 17 ENG_NAME Type : TEXT 35 18 EXC_KEY Type : DOUBLE 19 HOST_CLLI Type : TEXT 15 20 TAND_CLLI Type : TEXT 14 21 CLLI_STATU Type : TEXT 13 22 NET_FUNCT Type : TEXT 29 23 SWITCH_TYP Type : TEXT 15 24 BU_SWITCH_ Type : TEXT 17 25 LATA_NAME Type : TEXT 26 26 LATA_NUMBE Type : DOUBLE Current number of rows: 65535 SCONNECT ";driver=R:BASE 8.0 Database Driver (*.rx1);dbq=L:\Amer;uid=xxxxx;pwd=xxxxxx" sattach clli as cll What other Information do you need? P.S. You Father was correct.... If you work hard, return your calls and ALWAYS DO WHAT IS RIGHT FOR THE CUSTOMER, you will be successful (or at least survive in a BRUTAL economy)

