Viewing 2 posts - 1 through 3 (of 3 total)
hi, Eirikur Eiriksson thank you for your reply.
I will try.
July 17, 2014 at 2:51 am
#1730154
I created query:
SELECT Distinct tr.EmpID, tr.TransDate,
Groups=MAX(Groups) Over (Partition By tr.EmpID, tr.Transdate, ms.Groups)
FROM dbo.Transactions tr INNER JOIN dbo.[Master] ms
...
July 16, 2014 at 10:31 pm
#1730095