Is your SQL code part of a SP?

Who calls that SP, is it interactive or not?

Depending on your situation, you might have some of the following options:

a) Call your SQL...