Get data changes from history table

Question

Post reply

Get data changes from history table

only_you

SSC Enthusiast

Points: 148
More actions
March 25, 2015 at 6:20 am

#302515

Hi,
how to get products on which SalesPerson changed. Here is table with data.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

djj SSCoach Points: 18831 More actions · Answer 1

only_you (3/25/2015)
Hi,
how to get products on which SalesPerson changed. Here is table with data.

Normally I would ask what have you tried...

Try a select that looks for IsLast as true.

only_you SSC Enthusiast Points: 148 More actions · Answer 2

Here is quary I'm looking for

SELECT ProductID

FROM Table

GROUP BY ProductID

HAVING COUNT(DISTINCT SalesPerson) > 1

Are there another ways?

djj SSCoach Points: 18831 More actions · Answer 3

only_you (3/25/2015)
Here is quary I'm looking for
SELECT ProductID
FROM Table
GROUP BY ProductID
HAVING COUNT(DISTINCT SalesPerson) > 1
Are there another ways?

SELECT *

FROM Table

WHERE IsLast = 1;

roger.price-1150775 Default port Points: 1458 More actions · Answer 4

What do you see as the problem with your query ?

The way I've done it in the past is much the same...

SELECT ProductID, MAX(SalesPerson), MIN(SalesPerson)

FROM Table

GROUP BY ProductID

HAVING MAX(SalesPerson) <> MIN(SalesPerson)

only_you SSC Enthusiast Points: 148 More actions · Answer 5

only_you

SSC Enthusiast

Points: 148

March 25, 2015 at 7:46 am

#1786308

How to include Date column in select?

Sean Lange SSC Guru Points: 286590 More actions · Answer 6

only_you (3/25/2015)
How to include Date column in select?

Which date do you want? The MAX or MIN? You either have to group by the date column or decide which one you want.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

ZZartin SSC-Dedicated Points: 30921 More actions · Answer 7

Based on the data you provided what is th expected output?

only_you SSC Enthusiast Points: 148 More actions · Answer 8

ProductID,oldSalesPerson,newSalesPerson, Date (when record updated)

Sean Lange SSC Guru Points: 286590 More actions · Answer 9

only_you (3/25/2015)
ProductID,oldSalesPerson,newSalesPerson, Date (when record updated)

Can you confirm which version of sql server you are using? Since you posted in the 2008 forum I assume that is correct. In 2008 you will need to use a recursive cte for this type of thing. If you can post consumable ddl and data I will help you. Take a few minutes and check out the first link in my signature.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/