Hi!

You can combine them in a single query:

SELECT SmtDetail.*
  FROM dbo.SmtDetail INNER JOIN
    (SELECT Member_Id, MAX(TS) AS Ts
       FROM dbo.SmtDetail
       GROUP BY Member_Id) MaxDetailTs ON
         dbo.SmtDetail.Member_Id = dbo.MaxDetailTs.Member_Id AND
         dbo.SmtDetail.TS = dbo.MaxDetailTs.Ts

>I would like to accomplish the following without having to construct the MaxDetailTS view:
>
>View MaxDetailTS:
>SELECT Member_Id, MAX(TS) AS Ts
>FROM dbo.SmtDetail
>GROUP BY Member_Id
>
>View DetailView:
>SELECT SmtDetail.*
>FROM dbo.SmtDetail INNER JOIN
> dbo.MaxDetailTs ON
> dbo.SmtDetail.Member_Id = dbo.MaxDetailTs.Member_Id AND
> dbo.SmtDetail.TS = dbo.MaxDetailTs.Ts
>
>Is there a more efficient and/or neater way to accomplish this?
>
>TIA