|
|
Posted by johntarr on 09/26/64 11:44
I hope I am not asking about something that has been done before, but I
have searched and cannot find an answer. What I am trying to do is to
run a query, and then perform some logic on the rowcount and then
possibly display the result of the query. I know it can be done with
ADO, but I need to do it in Query Analyzer. The query looks like this:
select Var
from DB
where SomeCriteria
if @@Rowcount = 0
select 'n/a'
else if @@Rowcount = 1
select -- this is the part where I need to redisplay the result
from the above query
else if @@Rowcount > 1
-- do something else
The reason that I want to do it without re-running the query is that I
want to minimize impact on the DB, and the reason that I can't use
another program is that I do not have a develpment environment where I
need to run the queries. I would select the data into a temp table, but
again, I am concerned about impacting the DB. Any suggestions would be
greatly appreciated. I am really hoping there is something as simple as
@@resultset, or something to that effect.
Navigation:
[Reply to this message]
|