​
ediff-diff-program = "diff" which I suspect is powershell "compare-object"
ediff-diff-options = defaults to --binary leads to the following
>diff: E200016: Error in options to internal diff
>
>diff: E200016: invalid option: --binary
ediff-diff-options = "" leads to an \*ediff-errors\* buffer which is a mixture of diff +/- lines not separated into colourized versions of original buffer
>\+++ c:/Users/u0138544/AppData/Local/Temp/pr\_GetFatherLastName.sql.\~181\~ Thu Mar 24 21:14:39 2022
>
>@@ -1,126 +1,208 @@
>
>\-use \[dbname\];
>
>\+USE \[dbname\]
>
> GO
>
>\-/\*\*\*\*\*\* Object: StoredProcedure \[Resolve\].\[pr\_GetFatherLastName\] Script Date: 1/27/2022 1:48:12 PM \*\*\*\*\*\*/
>
>\-SET ANSI\_NULLS ON;
>
>\+/\*\*\*\*\*\* Object: StoredProcedure \[Resolve\].\[pr\_GetFatherLastName\] Script Date: 4/13/2017 2:32:24 PM \*\*\*\*\*\*/
>
>\+SET ANSI\_NULLS ON
>
> GO
>
>\-SET QUOTED\_IDENTIFIER ON;
>
>\+SET QUOTED\_IDENTIFIER ON
>
> GO
>
>\+
>
>\+/\*\*\*\*\*\* Object: StoredProcedure \[Resolve\].\[pr\_GetFatherLastName\] Script Date: 03/17/2015 14:54:03 \*\*\*\*\*\*/
>
> \-- =============================================
>
>\+-- Author: Justin Berger
>
> \-- Create date: 2015-01-28
>
> \-- Description: Gets the Father's last name
>
> \-- =============================================
>
>\-CREATE or ALTER PROCEDURE resolve.\[pr\_GetFatherLastName\]
>
>\- u/MappingInstructionID INT,
>
>\- u/NewPersonID INT
>
>\+ALTER PROCEDURE \[Resolve\].\[pr\_GetFatherLastName\] u/MappingInstructionID INT
>
>\+ , u/NewPersonID INT
>
> AS
>
> BEGIN
>
>\- SET NOCOUNT ON;
>
>\+ SET NOCOUNT ON;
>
>
>
>\- DECLARE u/APIDS TABLE
>
>\- (
>
>\- ArchivePersonID INT,
>
>\- --RecordType VARCHAR(15),
>
>\- RecordRole VARCHAR(10)
>
>\- );
>
>\- DECLARE u/RecordType VARCHAR(15),
>
>\- u/StartTime DATETIME2 = SYSDATETIME(),
>
>\- u/TaskStart DATETIME2 = SYSDATETIME(),
>
>\- u/TaskEnd DATETIME2 = SYSDATETIME(),
>
>\- u/Message VARCHAR(250),
>
>\- u/Timing CHAR(1),
>
>\- u/BCExists bit;
>
>\+ DECLARE u/APIDS TABLE (
>
>\+ ArchivePersonID INT
>
>\+ , RecordType VARCHAR(15)
>
>\+ , RecordRole VARCHAR(10)
>
>\+ )
>
>\+ DECLARE u/RecordType VARCHAR(15)