Home Forums SQL Server 2008 T-SQL (SS2K8) Remove a Simple Duplicate RE: Remove a Simple Duplicate
AlexSQLForums
SSChampion
Points: 14277
More actions
May 1, 2014 at 12:01 pm
#1710183
If you only see nulls in areacode and phonenumber you can get rid of them with temp table like john mentioned
select into #t1
from @somedata where AreaCode is not null and PhoneNumber is not null