if a sql uses a bind variable, when one goes to automate and publish it runs and gets an error that it has bind variables. the only way to add a bind variable is to manually add a variable and modify the sql to say where somefield = '#variable1#'. this is not ideal.