Wrox Programmer Forums
|
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 15th, 2009, 02:41 PM
Registered User
 
Join Date: Aug 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Except statment

Hello:
I am using the "except" statement to find unique records between two tables in SQL Express 2005.
Each table has approx 87,000 records.
When using just a very small subset of each table, let's say 10 records it works fine but when using the whole 87k records I get back all the records from the table on the left of the "except".
Does anyone know of a record limit to this function?

Thanks
Robert





Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with IIF Statment Corey Access 2 December 14th, 2006 11:10 AM
What is wrong with this update statment ? method SQL Server 2000 2 April 23rd, 2005 04:45 AM
if statment knightm28 Classic ASP Databases 2 April 1st, 2005 11:08 AM
SQL Statment btpoole VB Databases Basics 1 February 18th, 2004 01:03 PM
SQL statment arshad mahmood VB Databases Basics 1 July 1st, 2003 02:10 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.