How do I check if query return 0 records

[gcole]

I need a statement that will return a 0 result from a query. I tried:
If Exists( select * from out_product
where productname not in
(select product from out_listownership))

but it doesn't return a false.

 

[jfrost10]

Are you trying to do this in T-SQL or another programming language?

Jack

 

[bperry]

I don't think we are clear on what you want, but you can try this to see if it close to what you are thinking. If not, perhaps try to describe a bit more what you are aiming at.
[tt]
Select (select count(*) from out_product
where productname not in
(select product from out_listownership)
) as TheCount
[/tt]

------------
bperry

 

[bperry]

When I re-read, I see you want to check if it is zero. Perhaps you mean something like this inside a stored procedure or script?

[tt]
declare @mycount int
select @mycount = (Select (select count(*)
from out_product
where productname not in
(select product from out_listownership))
if @mycount = 0
do this
else
do that
-------------------
[/tt]

 

[tlbroadbent]

Try this.

If Exists
(Select *
From out_product a
Join out_listownership b
On a.productname = b.product) Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.