Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)
Segment connects to Street using the Street_ID
UPDATE Segment SET Segment.street_Full_Name = st.street_Full_Name, from dbo.Street st INNER JOIN INSERTED i ON st.OID = i.OID INNER JOIN dbo.Segment s ON s.Street_ID = st.Street_ID
Join the community of 500,000 technology professionals and ask your questions.