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

Re: conditional query

From	"Bob Barrows" <reb01501@NOyahooSPAM.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: conditional query
Date	2011-08-23 14:11 -0400
Organization	A noiseless patient Spider
Message-ID	<j30qjb$b7d$1@dont-email.me> (permalink)
References	<6d06d2ab-012b-4e50-a734-9c71a7dc31c6@s7g2000yqd.googlegroups.com>

Show all headers | View raw

Harry wrote:
> 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.
>
>
So the desired result from this sample data would be an empty resultset?
What do you want to display when the data actually contains rows that meet
your requirement? All the rows for that name and date? Or a single row for
that name and date?
Why don't you try again. Show us some sample data that includes data that
meets your requirements and then show us what you want the desired query to
return. The key being "show" - don't just describe the desired result: show
it to us.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next 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