Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kHebTrekInWatLekkers
Starting Member
3 Posts |
 Posted - 2001-08-10 : 06:08:30
|
| In a select query I use a counter. This is so far no problem. The problem is the I need an expression when he needs to count. For example: Count(A when A< 100). How can I do this? My SQL string looks sofar: SELECT Kantoor.Naam, Kantoor.Kantoornummer, [Soort geval].Gevalssoort, Claimbehandelaar.Familienaam, Claimbehandelaar.Voorvoegsels, Claimbehandelaar.Voornaam, Count(Gevallen.Outputdatum) AS Totaal, Count(Gevallen.[EWD-DTA]+[Soort geval].[PI-Meetmoment]-Gevallen.Outputdatum ) as Verschil FROM [Soort geval] INNER JOIN (((Kantoor INNER JOIN Teams ON (Kantoor.[Kantoor-ID] = Teams.[Kantoor-ID]) AND (Kantoor.[Kantoor-ID] = Teams.[Kantoor-ID])) INNER JOIN Claimbehandelaar ON (Teams.[Team-ID] = Claimbehandelaar.[Team-ID]) AND (Teams.[Team-ID] = Claimbehandelaar.[Team-ID])) INNER JOIN Gevallen ON (Teams.[Team-ID] = Gevallen.[Team-ID]) AND (Claimbehandelaar.[Claimbehandelaar-ID] = Gevallen.[Claimbehandelaar-ID])) ON [Soort geval].[Gevalssoort-ID] = Gevallen.[Gevalssoort-ID] WHERE (((Gevallen.Outputdatum) Is Not Null)) GROUP BY Kantoor.Naam, Kantoor.Kantoornummer, [Soort geval].Gevalssoort, Claimbehandelaar.Familienaam, Claimbehandelaar.Voorvoegsels, Claimbehandelaar.Voornaam; When "Verschil" wich has a numric value is smaller then 0 then he must count. |
|
|
|
|
|
Counter......