0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Ubuntu users and developers

declare @phoneNumbers table(
  oldNumber varchar(20),
  newNumber varchar(20)
);

insert into @phoneNumbers(oldNumber) values('0102547894')
insert into @phoneNumbers(oldNumber) values('0162554852')
insert into @phoneNumbers(oldNumber) values('0192025514')
insert into @phoneNumbers(oldNumber) values('0151257894')
insert into @phoneNumbers(oldNumber) values('01515474894')

insert into @phoneNumbers(oldNumber) values('0122547894')
insert into @phoneNumbers(oldNumber) values('0182547894')
insert into @phoneNumbers(oldNumber) values('0172547894')
insert into @phoneNumbers(oldNumber) values('0150547894')
insert into @phoneNumbers(oldNumber) values('01501547894')

insert into @phoneNumbers(oldNumber) values('0112547894')
insert into @phoneNumbers(oldNumber) values('0142547894')
insert into @phoneNumbers(oldNumber) values('0152047894')
insert into @phoneNumbers(oldNumber) values('01529656894')

SELECT * FROM @phoneNumbers

view current version

edited mar 29 12

created mar 29 12 anonymous