Viewing 3 posts - 1 through 3 (of 3 total)
ProductID,oldSalesPerson,newSalesPerson, Date (when record updated)
March 25, 2015 at 8:05 am
#1786320
How to include Date column in select?
March 25, 2015 at 7:46 am
#1786308
Here is quary I'm looking for
SELECT ProductID
FROM Table
GROUP BY ProductID
HAVING COUNT(DISTINCT SalesPerson) > 1
Are there another ways?
March 25, 2015 at 7:05 am
#1786278