Hi All I have a table in below format
Candidate Number ActivityCode Date
1 Submission 11/01/2015
2 Submission 11/08/2015
3 Submission 10/08/2015
1 ResumeScreen 11/05/2015
3 ResumeScreen 11/14/2015
2 ResumeScreen 11/19/2015
I want my output to be something like this
Candidate Number ActivityCode Date SubmissionDate ResumeScreenDate
1 Submission 11/01/2015 11/01/2015 11/05/2015
2 Submission 11/08/2015 11/08/2015 11/19/2015
3 Submission 10/08/2015 10/08/2018 11/14/2015
1 ResumeScreen 11/05/2015 11/01/2015 11/05/2015
3 ResumeScreen 11/14/2015 10/08/2015 11/14/2015
2 ResumeScreen 11/19/2015 11/08/2015 11/19/2015
I need to check for every candidatenumber the date when activity has happened and make it as a new column.
Can someone please help me how i can achieve this logic using T-SQL?
Thanks in Advance