Solved

DELETE QUERY QUESTION - EASY

Posted on 2008-10-08
2
166 Views
Last Modified: 2012-05-05
Simply put, I need to know how to implement a DELETE query within my SPROC that basically deletes ANY row WHERE GPS.TEXT_MESSAGE DOES NOT = '*Dispatched' or '*Starting Trip' or '*Ending Trip'

0
Comment
Question by:chrisryhal
2 Comments
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 500 total points
ID: 22670562
Here you go:

delete from gps
where YourPrimaryKeyField not in
     (select YourPrimaryKeyField from gps where texT_message in ('*Dispatched','*Starting Trip', '*Ending Trip')
     )
0
 
LVL 2

Author Closing Comment

by:chrisryhal
ID: 31504308
PERFECT!!!
0

Featured Post

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Sql query 12 68
How to SUM hours for the same record 1 34
SQL Server Degrading on Write 13 64
Pivot Query Problem 9 38
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now