Timeline for Return multiples tables with procedure
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 2, 2018 at 14:03 | comment | added | Bahtiyar Samet Çoban | I edited your SP to return 1 column only as you wanted. If you want to return two columns (OpenDate and CloseDate) for each job result set, this needs to be edited again. | |
| Nov 2, 2018 at 14:01 | history | edited | Bahtiyar Samet Çoban | CC BY-SA 4.0 |
added 380 characters in body
|
| Nov 2, 2018 at 13:07 | history | edited | Bahtiyar Samet Çoban | CC BY-SA 4.0 |
added 334 characters in body
|
| Nov 2, 2018 at 13:06 | comment | added | Skitzafreak |
If you see the edit I made to the OP to include what I currently have for the procedure, I essentially want to be able to output a column named 'OpenDate' with the date where the status_description is 'Open' and a column named 'CloseDate' where the status_description is 'Closed'.
|
|
| Nov 2, 2018 at 13:00 | comment | added | Bahtiyar Samet Çoban | so you want to understand whether it is open or closed for a job number you are sending to procedure, am I correct? If that is the case, i will update the procedure with union all case. | |
| Nov 2, 2018 at 12:47 | comment | added | Skitzafreak |
You made a correct assumption for my typo, which I fixed in the OP. The issue I am having, is I am not looking for just when status_description is Equal to 'Open' or 'Closed'. I specifically need to select the entry for 'Open' AND the entry for 'Closed'.
|
|
| Nov 2, 2018 at 12:43 | history | answered | Bahtiyar Samet Çoban | CC BY-SA 4.0 |