RE: Database Top X Records

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Bob Smith <BobSmith@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 9 Apr 2009 14:51:01 -0700

Figured it out, the Order by was set to a field that had many records with
the same value.

"Bob Smith" wrote:

I have a select statement that includes the TOP 3 records. I'm not sure why,
but for some reason it returns 8 records. I also tested Select Top 9 and it
returns 16 records. Is there some limitation in Visual Studio 8 that would
have a minimum number of records returned. I know my select statements are
correct because if I put them in SQL Enterprise Manager 3 records are
returned.

References:
- Database Top X Records
  - From: Bob Smith

Prev by Date: In design mode, Toolbox and Property window are broke.
Next by Date: Re: '/ZI' and '/clr' command-line options incompatible
Previous by thread: Database Top X Records
Next by thread: '/ZI' and '/clr' command-line options incompatible
Index(es):
- Date
- Thread

Relevant Pages

Database Top X Records
... but for some reason it returns 8 records. ... Is there some limitation in Visual Studio 8 that would ... correct because if I put them in SQL Enterprise Manager 3 records are ...
(microsoft.public.vstudio.general)
Re: Borland Delays Quarterly Results
... but Visual Basic was the only real native development ... development tools in earlier versions of Visual Studio .NET, ... The only reason you an do native ... Life is complex. ...
(borland.public.delphi.non-technical)
Re: Usenet employs and entirely different currency.
... He was quite a "regular" on COLA (and he is a devout Windows / Visual Studio ... Jeff revolutionises physics in sci.physics. ... Brad tries to reason with the voices in his head... ... "General Relativity is a Tower of Babel that wastes time, ...
(sci.geo.geology)
Re: Proxy creation - why is there more than 1 way?
... > One reason is that Visual Studio is just a tool for creating .NET apps. ... > The other reason really boils down to how you want to use the web service. ... > Reference through Visual Studio will create the proxy class and, ...
(microsoft.public.dotnet.framework.aspnet)
Re: Proxy creation - why is there more than 1 way?
... One reason is that Visual Studio is just a tool for creating .NET apps. ... The other reason really boils down to how you want to use the web service. ... Reference through Visual Studio will create the proxy class and, ...
(microsoft.public.dotnet.framework.aspnet)