crazy_new (1/28/2014)
Just below that I set the value.SET @ADR3 = (SELECT ADR3
FROM PAT_NAMES_ADDRESS
WHERE ADR1 = @ADDRESS)
SET @ADDRESS = 'M & B Pumps Division'
So search for all rows matching a specific address, then after it's finished the search set the value to the address that should have been searched for?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability