C# Outer Apply in LINQ

Posted by JeremySpouken on Stack Overflow See other posts from Stack Overflow or by JeremySpouken
Published on 2010-06-10T12:39:05Z Indexed on 2010/06/10 12:42 UTC
Read the original article Hit count: 343

SELECT u.masterID
      ,u.user
      ,h.created
FROM dbo.Users u
OUTER APPLY (SELECT TOP 1 * FROM UserHistory h where h.masterID = u.masterID ORDER BY created DESC) h

© Stack Overflow or respective owner