Very much appreciated! 🙂

Hey there, thanks! yes indeed, as I said, planning on moving to a different ETL tool then I'd take the time to design the whole process from scratch and will...

Changed it to Varchar(25) and it works.

Thanks for the help!

I couldn't agree more.. nasty trigger and in the near future my plan is to move to a different ETL tool...

ALTER Trigger [Table1UpdTrg]

On [Table1]

After Update

As

Declare @msgProfileNameVarchar(100)

Declare @msgRecipientsVarchar(100)

Declare @msgBodyVarchar(255)

Declare @msgSubjectVarchar(100)

Declare @IDInteger

Declare @NameOldVarchar(250)

Declare @NameNewVarchar(250)

Select @msgProfileName='Administrators'

Select @msgRecipients='Admin@xyz.com'

-- Disallow updates to any PK columns:

If Update( ID )

Begin

Rollback Transaction

RaisError('ERROR: Updates to Primary Key Columns Not...

Hi,

Thanks for your reply.

Just a quick background - this is a dim table that gets updated via ETL process, the ETL process is a few years old, nothing had changed...

If you hear of something within the NYC area, give me a shout 🙂

Actually.. I don't have permission to create temp tables.. and I won't have in the near future so I spend a lot of time working around this, instead of working...

Thank you so much for the reply.

Not studies but impossible restrictions at my work place.

I've used HAVING and sub query.