T
TTP
I need assistance really bad. I have posted 2 different requests for
assistance. Both had responses posted; but I can't see the responses. If
you can see the responses or have any suggestions, can you e-mail the
suggested approach to me at (e-mail address removed)?
Issue: I have the table below. I need to retrieve all steam records and
all generator records except the ones with GCE in ORDER_SOURCE field. I
defined the following criteria (Where TURBINE_TECH = "STEAM" Or (TURBINE_TECH
= "GEN*" And ORDER_SOURCE <>"GCE"). But, the resulting output does not
include the records with steam and GCE.
ORDER_NUM TURBINE_TECH ORDER_TYPE ORDER_SOURCE
1041772 GENERATOR Contractual Services GCE
1041812 STEAM Energy Parts - GEII Copy
1041818 GENERATOR Performance Services EAM AUTOLOAD
1041911 STEAM Energy Parts - GEII GCE
1000075 GENERATOR Performance Services CONVORDERS
So, my output should include all records above except the 1st one. Can
anyone assist me? Please e-mail me at (e-mail address removed)
assistance. Both had responses posted; but I can't see the responses. If
you can see the responses or have any suggestions, can you e-mail the
suggested approach to me at (e-mail address removed)?
Issue: I have the table below. I need to retrieve all steam records and
all generator records except the ones with GCE in ORDER_SOURCE field. I
defined the following criteria (Where TURBINE_TECH = "STEAM" Or (TURBINE_TECH
= "GEN*" And ORDER_SOURCE <>"GCE"). But, the resulting output does not
include the records with steam and GCE.
ORDER_NUM TURBINE_TECH ORDER_TYPE ORDER_SOURCE
1041772 GENERATOR Contractual Services GCE
1041812 STEAM Energy Parts - GEII Copy
1041818 GENERATOR Performance Services EAM AUTOLOAD
1041911 STEAM Energy Parts - GEII GCE
1000075 GENERATOR Performance Services CONVORDERS
So, my output should include all records above except the 1st one. Can
anyone assist me? Please e-mail me at (e-mail address removed)