Groups > comp.databases.ms-sqlserver > #626

Re: conditional query

From	Yonghang Wang <wyhang@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: conditional query
Date	2011-08-24 21:21 -0700
Organization	http://groups.google.com
Message-ID	<daa4ed0f-caa3-4b75-a15f-1741a774c509@glegroupsg2000goo.googlegroups.com> (permalink)
References	<6d06d2ab-012b-4e50-a734-9c71a7dc31c6@s7g2000yqd.googlegroups.com> <j30qjb$b7d$1@dont-email.me> <9d3c54c1-361f-41be-92cc-be2c95afa66b@p10g2000yqi.googlegroups.com> <966b76c5-6b95-4c98-a593-cc4d433a2803@glegroupsg2000goo.googlegroups.com> <j33r3i$nfp$1@dont-email.me>

Show all headers | View raw

oh,yes, u'r right. I made a mistake when tried to find some shortcut. how about change the predicate to :

having count(distinct proc) = 1 and count(*) > 1

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

conditional query Harry <hamackey@gmail.com> - 2011-08-23 06:49 -0700
  Re: conditional query Henk van den Berg <me@myplace.net> - 2011-08-23 19:41 +0200
    Re: conditional query Harry <hamackey@gmail.com> - 2011-08-23 10:56 -0700
      Re: conditional query Henk van den Berg <me@myplace.net> - 2011-08-23 23:04 +0200
  Re: conditional query "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-08-23 14:11 -0400
    Re: conditional query Harry <hamackey@gmail.com> - 2011-08-23 12:06 -0700
      Re: conditional query "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-08-23 15:35 -0400
      Re: conditional query Yonghang Wang <wyhang@gmail.com> - 2011-08-24 13:53 -0700
        Re: conditional query "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2011-08-24 17:34 -0400
          Re: conditional query Yonghang Wang <wyhang@gmail.com> - 2011-08-24 21:21 -0700

csiph-web