Timeline for View to insert records into history table and then find changes with Except query
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| S Feb 16, 2022 at 20:16 | history | edited | John K. N. | CC BY-SA 4.0 |
added tags; cleaned up code according to question; quoted error message;
|
| Feb 16, 2022 at 19:01 | vote | accept | ERPISE | ||
| Feb 16, 2022 at 18:58 | answer | added | J.D. | timeline score: 2 | |
| Feb 16, 2022 at 18:44 | comment | added | ERPISE | I need to insert the records for the last Run Date first, then open the view to see changes. Does the insert have to go in a stored procedure or script task in SSIS? | |
| Feb 16, 2022 at 18:41 | review | Suggested edits | |||
| S Feb 16, 2022 at 20:16 | |||||
| Feb 16, 2022 at 18:40 | comment | added | J.D. |
Are you trying to put INSERT INTO [dbo].[Acc-Faculty-History] inside of your view?
|
|
| Feb 16, 2022 at 17:11 | history | edited | ERPISE | CC BY-SA 4.0 |
added 150 characters in body
|
| S Feb 16, 2022 at 17:01 | review | First questions | |||
| Feb 16, 2022 at 18:41 | |||||
| S Feb 16, 2022 at 17:01 | history | asked | ERPISE | CC BY-SA 4.0 |