Re: SELECT COUNT(*) returning wrong value
From: Adam Machanic (amachanic_at_hotmail._removetoemail_.com)
Date: 08/26/04
- Next message: Zeng: "Clustered index vs. nonclustered index for GUID primary key"
- Previous message: Stan Rozendal: "Re: SELECT COUNT(*) returning wrong value"
- In reply to: Stan Rozendal: "Re: SELECT COUNT(*) returning wrong value"
- Next in thread: Tibor Karaszi: "Re: SELECT COUNT(*) returning wrong value"
- Reply: Tibor Karaszi: "Re: SELECT COUNT(*) returning wrong value"
- Reply: Stan Rozendal: "Re: SELECT COUNT(*) returning wrong value"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 25 Aug 2004 20:37:46 -0400
Next step I might take is to create a new database (preferably on a
different server) and use DTS to copy those two tables over to it... Then
run the same queries and see what happens. If that doesn't work out, post
DDL (CREATE TABLE statements) and some sample data (INSERT statements) to
reproduce the problem so I can try it on my end.
By the way, are you running the latest service pack? If not, try updating
that first.
"Stan Rozendal" <StanRozendal@discussions.microsoft.com> wrote in message
news:385793CF-A9E1-47CD-A290-C7F2C1B1D84A@microsoft.com...
>
> I tried the SELECT again but still getting the same results.
>
- Next message: Zeng: "Clustered index vs. nonclustered index for GUID primary key"
- Previous message: Stan Rozendal: "Re: SELECT COUNT(*) returning wrong value"
- In reply to: Stan Rozendal: "Re: SELECT COUNT(*) returning wrong value"
- Next in thread: Tibor Karaszi: "Re: SELECT COUNT(*) returning wrong value"
- Reply: Tibor Karaszi: "Re: SELECT COUNT(*) returning wrong value"
- Reply: Stan Rozendal: "Re: SELECT COUNT(*) returning wrong value"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
