Using Variable Multiple times in one statement
666715Oct 22 2008 — edited Oct 23 2008I've tried searching but can't seem to find any other threads where people have this problem.
I'm using a select statement, and within it, I have the same variable being used multiple times. The problem is that when I execute the statement, The variable subsitution box pops up as many times as the variable shows up in the statement. It's not a show stopper, but it's rather annoying. Is there an option somewhere that I'm not seeing that would make this work by only popping up once?