Any suggestions?

Maybe that's what I'm trying to ask, how do I only show diff's based upon columns that could be used for sort or key.

Thanks.

How do you turn the above script into my requirement.

Thx.

I'm on Standard 2012 edition.

Thanks for your efforts and input.

CREATE TABLE [dbo].[Error_Log](
[Error_Log_ID] [bigint] IDENTITY(1,1) NOT NULL,
[Error_DateTime] [datetime] NULL,
[Error_Type] [nvarchar](50) NULL,
[Error_Description] [nvarchar](max) NOT NULL,
[Error_User] [nvarchar](50) NULL,
[Error_Session] [nvarchar](50) NULL,
[Error_Procedure]...

Worked perfect thanks!!!!

It's not that I'm unwilling to do a rewrite, it's I just like to make what is running today more efficient. I have already begun the process

to tear apart the...

Do you need to see other pieces of the code?

Thanks

When I run the piece for creating #staging:

Column name or number of supplied values does not match table definition.

Thx,

Error-Log process

Thanks Scott.

ALTER PROCEDURE [dbo].[Write_Error_Log]
-- Input parameters.
@Type nvarchar(50) = N'ERROR',
@Description nvarchar(MAX) = NULL,
@Procedure nvarchar(50) = NULL,
@Code int = NULL,

-- Output parameters.
@Result nvarchar(MAX) = NULL OUT
AS
BEGIN
-- SET NOCOUNT...

Thanks will test the Code out!!

ANy more suggestions for the re-write?

Thanks Except seems to work for what I need.

Thanks Again!!

Any other things I can try to figure out why script isn't working?

Thanks.

You where correct with the " It's the ol' "data mart"... It's kind of a hybrid table.

Will that effect the Delta output?

THanks.

This debug script is returning data as expected.

Thanks.