IF OBJECT_ID('tSQLt.AssertEqualsTable') IS NOT NULL DROP PROCEDURE tSQLt.AssertEqualsTable;

CREATE PROCEDURE tSQLt.AssertEqualsTable

@Expected NVARCHAR(MAX),

@Actual NVARCHAR(MAX),

@Message NVARCHAR(MAX) = NULL,

@FailMsg NVARCHAR(MAX) = 'Unexpected/missing resultset rows!'

EXEC tSQLt.AssertObjectExists @Expected;

EXEC tSQLt.AssertObjectExists @Actual;

DECLARE @ResultTable NVARCHAR(MAX);

DECLARE @ResultColumn NVARCHAR(MAX);

DECLARE @ColumnList NVARCHAR(MAX);

DECLARE @UnequalRowsExist INT;

DECLARE @CombinedMessage NVARCHAR(MAX);

SELECT @ResultTable = tSQLt.Private::CreateUniqueObjectName();

SELECT @ResultColumn = 'RC_' + @ResultTable;

EXEC tSQLt.Private_CreateResultTableForCompareTables

@ResultTable = @ResultTable,

@ResultColumn = @ResultColumn,

@BaseTable = @Expected;

SELECT @ColumnList = tSQLt.Private_GetCommaSeparatedColumnList(@ResultTable, @ResultColumn);

EXEC tSQLt.Private_ValidateThatAllDataTypesInTableAreSupported @ResultTable, @ColumnList;

EXEC @UnequalRowsExist = tSQLt.Private_CompareTables

@Expected = @Expected,

@Actual = @Actual,

@ResultTable = @ResultTable,

@ColumnList = @ColumnList,

@MatchIndicatorColumnName = @ResultColumn;

SET @CombinedMessage = ISNULL(@Message + CHAR(13) + CHAR(10),'') + @FailMsg;

EXEC tSQLt.Private_CompareTablesFailIfUnequalRowsExists

@UnequalRowsExist = @UnequalRowsExist,

@ResultTable = @ResultTable,

@ResultColumn = @ResultColumn,

@ColumnList = @ColumnList,

@FailMsg = @CombinedMessage;

END;