Toad World® Forums

RE: Where statements (UNCLASSIFIED)


#1

Classification: UNCLASSIFIED
Caveats: NONE
Here is an example of 2 records (the remaining 2 places are null on both). As you can see, UIC and UIC2 are identical but the value WAB6FF is in UIC4 for the 1st record and UIC3 for the second. UIC UIC2 UIC3 UIC4 UIC5 UNIT_UIC
WATGFF W4FG18 WDEQFF WAB6FF WJJTAA WJJTB0
WATGFF W4FG18 WAB6FF WJJTAA {null} WJJTB0
Tim Payne
Stat Team Lead - ORSA
USACR/SC
(334)255-2075
email: james.t.payne20.civ@mail.mil
CAUTION: This electronic transmission may contain information protected by deliberative process or other privilege, which is protected from disclosure under the Freedom of Information Act, 5 U.S.C. § 552. The information is intended for the use of the individual or agency to which it was sent. If you are not the intended recipient, be aware that any disclosure, distribution or use of the contents of this information is prohibited. Do not release outside of DoD channels without prior authorization from the sender. The sender provides no assurance as to the integrity of the content of this electronic transmission after it has been sent and received by the intended email recipient. -----Original Message-----
From: GregDavis11009 [mailto:bounce-GregDavis11009@toadworld.com] Sent: Wednesday, March 19, 2014 9:36 AM
To: toaddatapoint@toadworld.com
Subject: RE: [Toad Data Point - Discussion Forum] Where statements
RE: Where statements Reply by GregDavis11009 Maybe I am missing something here but can’t you just use the same variable multiple times in your query instead of multiple variables with the same value?
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad Data Point - General notifications altogether. Toad Data Point - Discussion Forum Flag this post as spam/abuse. Classification: UNCLASSIFIED
Caveats: NONE