My peoplesoft FSCM database has 55145 tables and 261 gb

My old ERP system has 1598 and 98 gb

The both have about the same number of years on them and ...

LOL this is a copy of a in Production Database that I made for a developer to test with...but he made changes in this database without making them in his...

I have the log files on the usb drive (no backup) these are the acutal was working database and log files.

I do not know how to convert your sql into a usable view on my server.

I am sorry but I am way lost.....

SELECT b.Load_ID

, NAME1

, HM_TRAILER

, HM_ARRIVAL_DATE

, CITY

, STATE

, MinTMS_EXT_REF_ID

, MaxTMS_EXT_REF_ID

FROM @t b INNER...

City and State should be the City and State that goes with the min stop the 10 or 010 must of the time but not all the time. Just what...

the po has the / in it and the rest is LOAD_ID,ORDER_NO,INV_ITEM_ID,QTY_REQUESTED,SHIP_CUST_NAME1,ADDRESS1,CITY,STATE,POSTAL

02961941/0296194245382059376064namestreet addresscityOH43068

02961941/0296194245382059376064namestreet addresscityOH43068

02961941/0296194245382059376064namestreet addresscityOH43068

02961941/0296194245382059376064namestreet addresscityOH43068

02961941/0296194245382059376087namestreet addresscityOH43068

02961941/0296194345382059376087namestreet addresscityOH43068

02961941/0296194445382059376087namestreet addresscityOH43068

02961941/0296194545382059376087namestreet addresscityOH43068

02961941/0296194645382059376087namestreet addresscityOH43068

02961941/0296194745382059376087namestreet addresscityOH43068

02961941/0296194845382059376087namestreet addresscityOH43068

02961941/0296194945382059376093namestreet addresscityOH43068

02961941/0296195045382059376093namestreet addresscityOH43068

02961941/0296195145382059376093namestreet addresscityOH43068

this is what I would like it to look like

I think this should work I could not see the forest for the trees so to speak.

SELECT DISTINCT A.BUSINESS_UNIT

,A.LOAD_ID

,A.TMS_EXT_REF_ID

,A.SHIP_TO_CUST_ID

,A.ADDRESS_SEQ_NUM

,A.CUST_NAME

...

First it does not matter if this is peoplesoft are not we are not writing this in peoplesoft query.

what I am looking for.

each load(LOAD_ID) has multiple stops (TMS_EXT_REF_ID) now I...

This code omits the loads with a note.

Well I would do that but I do not know how and I would like to know how. I also would like to know how you posted you query in...

I uploaded the results of a showplan for the two SQL statements,

I will Test this to day to see what the performance difference is and post the results

Thanks

Thanks

this is what I ended up with:

select A.CUST_ID,A.NAME1, B.ADDRESS1, B.CITY

,B.STATE, B.POSTAL,C.PYMNT_TERMS_CD, D.CR_LIMIT

from PS_CUSTOMER (nolock) A

inner join PS_CUST_ADDRESS (nolock) B

on A.CUST_ID=B.CUST_ID

...