SQL Refactor qualifying columns with function name

andy3180

In a case where the code selects columns from a function, SQL Refactor is prefixing the function names to the columns which is results in an error while trying to execute that code in Query Analyzer

e.g. SELECT Col1, Col2 FROM funcXYZ(10, 20)
is changed to
SELECT funcXYZ.Col1, funcXYZ.Col2 FROM funcXYZ(10, 20)

This results in the following error -

The multi-part identifier "funcXYZ.Col1" could not be bound

Brian Donahue

Thanks, I have reported this to the development team for fix action. Refactor has been trained to not qualify ALTER queries on functions, but it looks like it doesn't ignore them on SELECT queries.