I read that I can create a dynamic query by setting QUOTED_IDENTIFIER OFF. This is true and I was able to make string values on the fly and it works great!
However, when I tried to turn the query into a Stored Procedure(Create Procedure) I got Error: Invalid column name '''. Is anyone familiar with QUOTED_IDENTIFIER who can tell me if there is anything I can do?
However, when I tried to turn the query into a Stored Procedure(Create Procedure) I got Error: Invalid column name '''. Is anyone familiar with QUOTED_IDENTIFIER who can tell me if there is anything I can do?