go
alter table [dbo].[OnlinePortfolio] add Custodian nvarchar(250),Registrars nvarchar(250)
go
update OnlinePortfolio
set Custodian = 'Citi Bank Limited',Registrars ='Meristem Registrars'
where ID_Portfolio = 81
go
update OnlinePortfolio
set Custodian = 'Citi Bank Limited',Registrars ='Meristem Registrars'
where ID_Portfolio = 82
go
update OnlinePortfolio
set Custodian = 'Citi Bank Limited',Registrars ='Meristem Registrars'
where ID_Portfolio = 83
go
update OnlinePortfolio
set Custodian = 'Stanbic IBTC Nominees Limited',Registrars ='Quantum Zenith Asset Management and Investments Limited'
where ID_Portfolio = 129