TABLE OF CONTENTS
- 1) Use this sql to copy the current row to a history table before changing data
- 2) Edit table [AirTransTracker].[Config].[tb_MagnaTechSec] and update PCCList
1) Use this sql to copy the current row to a history table before changing data
declare @Description varchar(250)
/* UPDATE DESCRIPTION TO DESCRIBE WHY A NEW ROW IS ADDED */
SET @Description = '[FreshDesk: 65041] Magnatech Synch Pcc - NI5L (Ginger Schacherbauer)'
SET @Description = LEFT(@Description, 250)
insert [Config].[tb_MagnaTechSec_History]
(
[UserPCC]
, [PCCList]
, [Description]
, [UserName]
, [Pwd]
)
select [UserPCC]
, [PCCList]
, @Description
, [UserName]
, [Pwd] = [Pwd]
FROM [AirTransTracker].[Config].[tb_MagnaTechSec]
2) Edit table [AirTransTracker].[Config].[tb_MagnaTechSec] and update PCCList
For US: D00187-AGRSQL01\AGRESSO
For CA: TOR-SQL02\CCCA
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article