Re: Select the most recent date

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Roji. P. Thomas (lazydragon_at_nowhere.com)
Date: 04/26/04 

Date: Mon, 26 Apr 2004 15:55:10 +0530

>From the OP

I want to find the <B>records<B> with the most recent ....
;) 

-- 
Roji. P. Thomas
SQL Server Programmer
"Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
news:ezksh81KEHA.988@TK2MSFTNGP11.phx.gbl...
> Yeah, I missed the plural.  But, depends also on what granularity the
> information is stored in, whether he meant "most recent date/time," and
> whether there is any likelihood of dupes.  ;-)
>
> -- 
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "Steve Kass" <skass@drew.edu> wrote in message
> news:OPebzd1KEHA.2660@TK2MSFTNGP09.phx.gbl...
> > SELECT TOP 1 WITH TIES <column list> ... ?
> >
> > SK
>
>

Relevant Pages

  • Re: Can we actually restrict granularity of locking
    ... If you ask for tablock for example, and someone has a rowlock on ... You can also restrict lock granularity by using sp_indexoption. ... SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: query help
    ... just not a create table script. ... Yeah, you did. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: top 10 reasons for 8Gb FC?
    ... Uh, yeah. ... This put a smile on my face ... ... How come MS SQL Server 2008 isn't up there as well? ... what init.ora parameter do I set to fix that?" ...
    (comp.databases.oracle.server)
  • Re: Measures group problem with different granularity
    ... It's not clear what the relationship of "Productid" to the granularity ... (direct or indirect) ... Microsoft MVP - SQL Server ...
    (microsoft.public.sqlserver.olap)
  • Re: Tips on finding memory leaks
    ... Oh, yeah, I also meant to mention, Access is primarily a front-end in this ... though with convenient access to the full set of SQL Server ... OLEDB issues definitely AREN'T the problem here. ...
    (microsoft.public.vb.general.discussion)