We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
select * from (select h.* , row_number() over (partition by h.product order by maxcreated desc) rn, a.ClientNumber as Client, a.product as product_num, c.Result, g.statetypename as StateType, b.status, h.maxcreated as DateCompleted FROM client a left join workstation b on a.productid= b.productid left join validationsummary c on a.productid= c.productid left join note d on a.productid= d.productid left join snapshot e on a.productid= e.productid left join workstationstep f on b.workstationid = f.workstationid left join statetype g on e.statetypeid = g.statetypeid left join mostrecent h on a.product = h.product WHERE (b.Template = 'MOD2') ) sq where sq.rn = 1
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|I have an unknown large SQL database I want to get rid of||10||44|
|How to create and use encrypted columns in SQL 2005?||15||62|
|File attachment in the SQL Database from application||10||45|
|How can I group this data in the following manner?||2||28|
Join the community of 500,000 technology professionals and ask your questions.