troubleshooting Question

Find The First Date When A Group Of Records In A Table Change

Avatar of thayduck
thayduckFlag for United States of America asked on
SQL
24 Comments1 Solution77 ViewsLast Modified:
I need to read Table1 and find the date 12/04/2017, which is in the first record in the group of records with a Cust# of A631, Date Code of 28 and Status Code of M.
Also would need to find date 03/01/2017 since that is first record of group  A722      33          M      etc...
 
Table1:

   Cust         DATE                DateCode     Status
    A631       12/01/2017          25                 C
    A631       12/01/2017          25                 D
    A631       12/02/2017          26                 I
    A631       12/03/2017          27                 J
    A631       12/04/2017          28                M
    A631       12/04/2017          28                M  
    A631       12/05/2017          28                M
    A631       12/06/2017          28                M
    A631       03/25/2018          28                M
    A721       02/13/2018          29                K
    A721       03/10/2018          30                J
    A722       03/01/2017          33               M
    A722       03/03/2017          33               M
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 24 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 24 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros