Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Omit Deleted Records from SQL-Select Query Results 1

Status
Not open for further replies.
AllanB1

AllanB1

Programmer
Dec 30, 2002
201
US
Hi.

Without PACKing the table, how would you exclude the deleted records from the query result?

...WHERE !DELETED() doesn't do it.

Thanks.

Al
 
Sort by date Sort by votes
SET DELETED ON.

That's the only reliable way, especially if the SQL queries more than one table. The SQL engine opens the tables with noonpredictable alias names while executing, therefore you also cannot work with DELETED('tablename').

Bye, Olaf.
 
Upvote 0 Downvote
Good catch Olaf. I thought SET DELETED was ON, but it wasn't.

Al
 
Upvote 0 Downvote
Well, okay. If you have data from deleted records in a query result, it's a sure sign DELETED is OFF.

Bye, Olaf.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

AndrewMozley
  • Locked
  • Question
Combining two tables using SQL-SELECT 1
Replies
5
Views
191
Chris Miller
Chris Miller
CBellucci
  • Locked
  • Question
Retrieving Images (varbinary(max)) from MS SQL Server 1
Replies
3
Views
718
Chris Miller
Chris Miller
AlastairP
  • Locked
  • Question
data query speed difference with SET DELETED ON/OFF 1
Replies
8
Views
233
Chris Miller
Chris Miller
Scott24x7
  • Locked
  • Question
COPY TO command results in all lower case 1
Replies
11
Views
233
Chris Miller
Chris Miller
tsibert
  • Locked
  • Question
Randomly displaying single or multiple records 2
2
Replies
25
Views
2K
Piotr Czekalski
Piotr Czekalski

Part and Inventory Search

Sponsor

Back
Top