Unanswered: having a select statement with no output
i have the following select query "select myCol from myTbl"
i cant modify the query but i can add to it;
what i want is to cancel the output of this query so it has no output( just like an update or insert query). a way for doing this is using 'select into' a #temp table but i cant do this becoz adding the 'into' at the end wont work after the 'from'.
i can use 'union all' to add another select statement but i cant use 'into' in the second statement becoz it has to be in the first one.
adding 'where 1=2' is not what i want becoz it still gives an empty output