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
|Do aggregate functions work differently when assigned to a variable?||15||31|
|Replace Dates in query||14||11|
|T-SQL: Carrying a Figure from One Row to the Next||13||17|
|ISDATE() not working properly on my table? Any suggestions.||7||0|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!