09. oktober 2001 - 15:33Der er
14 kommentarer og 1 løsning
SQL streng
Jeg har en sql streng, som næsten gør hvad den skal:
Select LevDato, IsNull(Sum(Tid_opsaet_estmrt_totalsek*Antal_profiler),0) As Opsaet, IsNull(Sum(Tid_pakning_estmrt_totalsek*Antal_profiler),0) As Pak from Ordrer
I ordrer er der også en celle der hedder Status. Her kommer problemet så ind. Det jeg gerne vil er: Select LevDato, HvisStatus<40(IsNull(Sum(Tid_opsaet_estmrt_totalsek*Antal_profiler),0)) As Opsaet, HvisStatus<80(IsNull(Sum(Tid_pakning_estmrt_totalsek*Antal_profiler),0)) As Pak from Ordrer
Select LevDato, IIf(Status<40,IsNull(Sum(Tid_opsaet_estmrt_totalsek*Antal_profiler),0),0) As Opsaet, IIf(Status<80,IsNull(Sum(Tid_pakning_estmrt_totalsek*Antal_profiler),0),0) As Pak from Ordrer
Det kan være at jeg er WAY OFF, men prøv den lige af...
The Iif function seems to be available only in connection with dataware house services - instead of the Iif you can use the CASE :
Select LevDato, CASE WHEN Status < 40 THEN IsNull(Sum(Tid_opsaet_estmrt_totalsek*Antal_profiler),0) ELSE 0 END AS Opsaet, CASE WHEN Status < 80 THEN IsNull(Sum(Tid_pakning_estmrt_totalsek*Antal_profiler),0) ELSE 0 END AS Pak from Ordrer
Terry - I think it is only Access that have problems with this because it is so stupid that it uses regional settings for list separators. SQL doesn\'t do that.
Try running this simple example in Query Analyzer:
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.
