Constraint Violating Yak Guru
Flowing Fount of Yak Knowledge
Select * from
Select *,ROW_NUMBER() OVER (PARTITION BY ISNULL(Job,'N/A') Order by Completed_date desc)as Seq
Where Z.Seq = 1
Very Important crosS Applying yaK Herder
quote:Originally posted by qmanThanks for the help, this work great.I have never used OVER/PARTITION, need to now figure out how it is working, lol....