Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


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

conditional query

From Harry <hamackey@gmail.com>
Newsgroups comp.databases.ms-sqlserver
Subject conditional query
Date 2011-08-23 06:49 -0700
Organization http://groups.google.com
Message-ID <6d06d2ab-012b-4e50-a734-9c71a7dc31c6@s7g2000yqd.googlegroups.com> (permalink)

Show all headers | View raw


I have a table with three columns:

Name         Date           Action
Fred           Today         this
Fred           Today         this
Fred            Today        that
Wilma         Today         this


I want to sort by name and by date, but only if 'this' was done more
than once on the same day, and not if 'that' was done on the same
day,They have to perform this more than once, and they cannot have
performed that on the same day.


Thanks,
Harry

Back to comp.databases.ms-sqlserver | Previous | NextNext 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