troubleshooting Question

T-SQL SQL Server 2000

Avatar of SQLM_M
SQLM_MFlag for India asked on
Microsoft SQL Server 2005Microsoft SQL Server 2008
9 Comments1 Solution315 ViewsLast Modified:
please suggest how to improve the performance for the below update statement.

General  substring(a.callednb, 1,11) need to provide other alternative method

update a
set a.trff_pfx = b.prefixcode,A.Destination=B.destcode   from #dest_asr  a , w_prefix B
where substring(a.callednb, 1,11) = b.prefixcode
and b.prefixlen = 11 and a.trff_pfx is null

Thanks,
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros