RE: IS NULL not working in WHERE clause.
From: Earl Newcomer (EarlNewcomer_at_discussions.microsoft.com)
Date: 12/17/04
- Next message: Earl Newcomer: "Re: IS NULL not working in WHERE clause."
- Previous message: Earl: "RE: IS NULL not working in WHERE clause."
- In reply to: Alejandro Mesa: "RE: IS NULL not working in WHERE clause."
- Next in thread: Brandon Lilly: "RE: IS NULL not working in WHERE clause."
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 17 Dec 2004 14:37:05 -0800
Please see my return post to David Portas. The table I am having problems
with contains over 277 million rows. The same query running against a table
with only one day of data (approx. 659,000 rows) works just fine.
"Alejandro Mesa" wrote:
> How can we reproduce the problem?
>
>
>
> AMB
>
>
> "Earl" wrote:
>
> > The following query returns rows where the time_id IS NOT NULL. This query
> > seems to be breaking SQL Server(?)
> >
> > select bus_date, time_ordered, time_id
> > from [vicorp\gillic].pmix_fact1
> > where bus_date = '2003-11-01'
> > and time_id is null
> > order by time_ordered
> >
> >
> > The following query does NOT return any rows where the time_id is null.
> >
> > select bus_date, time_ordered, time_id
> > from [vicorp\gillic].pmix_fact1
> > where bus_date = '2003-11-01'
> > and time_ordered between '2003-10-31 00:05:54' and '2003-11-05 13:38:11'
> > and time_id is null
> > order by time_ordered
> >
> >
- Next message: Earl Newcomer: "Re: IS NULL not working in WHERE clause."
- Previous message: Earl: "RE: IS NULL not working in WHERE clause."
- In reply to: Alejandro Mesa: "RE: IS NULL not working in WHERE clause."
- Next in thread: Brandon Lilly: "RE: IS NULL not working in WHERE clause."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
