... darkrealms ...

Forums before death by AOL, social media and spammers... "We can't have nice things"

comp.databases.ms-sqlserver

Notorious Rube Goldberg contraption

19,505 messages

[ << oldest | < older | list | newer > | newest >> ]

Message 18,260 of 19,505

Lennart Jonsson to All

Re: Help needed to write a qury

25 Apr 11 17:44:28

   From: erik.lennart.jonsson@gmail.com   
      
   2011-04-24 21:51, Erland Sommarskog skrev:   
   [...]   
   > Fred who posted the other solution should take notice. The row_number   
   > function, added in SQL 2005, is much more efficient in numbering the rows   
   > than using a subquery.   
   >   
      
   Any rumors on lead and/or lag analytical functions in sqlserver?   
      
      
   /Lennart   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)

[ << oldest | < older | list | newer > | newest >> ]