home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 18,424 of 19,505   
   Henk van den Berg to Harry   
   Re: conditional query   
   23 Aug 11 19:41:06   
   
   0908f969   
   From: me@myplace.net   
      
   Now what possible actions might this/that be?   
      
   This: drive to bowling alley   
   That: Feed Dino   
      
   Looks very much like a homework assignment to me...   
      
   Harry schreef op 23-08-2011 15:49:   
   > 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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca