New numbering plan

Starting from 17th of October 2008, all mobile and line numbers in Kuwait will change to 8 digits.

This plan principle is straightforward for the public communication in Kuwait. But as an IT worker, I had been heavily occupied by this new arrangement. *sigh*

declare @tables table([name] varchar(50))
declare @table varchar(50)

– find tables contain dslnumber
insert into @tables
SELECT usr.[name]+‘.’+obj.[name]
FROM sysobjects obj inner join sysusers usr on obj.uid = usr.uid
WHERE obj.id IN ( SELECT id FROM syscolumns WHERE name = ‘dslnumber’ ) and obj.type=‘U’ order by obj.[name] asc

SELECT TOP 1 @table = [name] from @tables WHERE [name] > @table order by [name] asc

while @@rowcount>0
begin
  exec(‘exec dslnumber_update @table= ’+ @table)

  SELECT TOP 1 @table = [name] from @tables WHERE [name] > @table order by [name] asc
end