Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,710

    SQL exclude query???

    Hello,

    I have data in a table and I need to exclude data if it meets a certain criteria. This need to produce a new table listing and be provided to a application. First, I need to:

    SELECT * FROM ACTIVITY
    WHERE
    ACTIVITY_NM LIKE '%UNKNOWN'

    And
    Garry D

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,621
    please be more vague to make answering more challenging.

    We do not know what you start with.
    We do not know what the actual results should be.
    Other than that your problem statement is as clear as mud.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    There are no stupid questions, but there are a LOT of Inquisitive Idiots.

  3. #3
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,710

    Cool SQL Exclude query????

    That's the difference from a DBA and a Developer, Left coast and Right coast. I think not like solves the issue for me. My problem is this is a application driven by developers. Not the database. So, the data is all #$%%$*&*(T(*&^)$. No referencial intergrity. Were if it was database driven. I would not need to clean up data to produce back to a application that will continue to have bad data in the database tables.

    Just a thought.

    Sorry, need to attend the SAN

    P.S.
    Please if you know of anyone in this industry coast to coast and world wide. Please have them to look at this sites "job opportunites" and appy.

    Thanks
    G
    Garry D

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,621
    THANKS for the clarification.

    NOT!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    There are no stupid questions, but there are a LOT of Inquisitive Idiots.

  5. #5
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,710

    Talking SQL Exclude query????

    With all your post. You got to be a vet with alot of experience. So when thing like this come up. Who has time to remember the coding you did 20 years ago. Hell, That's how I got my start in the industry. Oh, yeah, we did have things like this this. You remember verion 5.0 of Oracle. THERE was no internet, Forum. hell. Email had just come along. The good old days.

    When technology move faster than a Bug and Elmer fud.
    Garry D

  6. #6
    Join Date
    Jun 2004
    Posts
    744
    One of the first rules I learnt when I started in IT was never to touch a keyboard if I'd been drinking...
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  7. #7
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,669

    Cool

    Quote Originally Posted by garrydawkins View Post
    ... So, the data is all #$%%$*&*(T(*&^)$. No referencial intergrity. Were if it was database driven. I would not need to clean up data to produce back to a application that will continue to have bad data in the database tables.
    If you try to fix (manipulate) the data in order to produce "acceptable" results, your customers (and developers) will get use to it and expect you to "fix" everytime the c.r.a.p. they enter (or allow to enter) the database.

    If you cannot have the developers fix their own data, RUN as fast as you can.
    Eventually they will blame YOU for the bad data.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •