The date in which the status changes is being collected in one column, no matter if the status is sent or resent, etc. I would like the two dates to be separated into two columns. If anyone could help, that would be great!
Again, I'm using SSMS 2018.
What my table looks like:
+-------+--------+--------+------------+
| Code | Name | Status | StatusDate |
+-------+--------+--------+------------+
| 221 | Kim | Resent| 2020-01-05|
| 221 | Kim | Sent | 2020-01-01|
+-------+--------+--------+---------+--+
What I want it to look like:
+-------+--------+--------+-----------+-----------+
| Code | Name | Type | SentDate | ResentDate|
+-------+--------+--------+-----------+-----------+
| 221 | Kim | Book | 2020-01-01| 2020-01-05|
+-------+--------+--------+---------+-------------+
question from:
https://stackoverflow.com/questions/65946378/separating-rows-into-columns 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…