Try our conversational search powered by Generative AI!
AI OnAI Off
Feb 11, 2020
Mar 16, 2020
Closed, Fixed and tested
Creation of two stored procedures (listed below) fails with the message "The correlation named 'w' is specified multiple times in a FROM clause."
This is because 'v' and 'w' are considered equal in Finnish_Swedish_CI_AI collation (specifically because it is accent insensitive - "AI"), and these stored procedures contain FROM clauses like
FROM someTable v INNER JOIN otherTable w on v.WorkId = w.WorkId
Stored procedures with this issue: