Sorry, found the issue.


use WZH;
GO


Hi Mark,

Thank you. 🙂

Cheers,

Julian

SELECTA.Week, A.SALDORCNW

FROMMedewerkerUren A

WHEREEXISTS

(

SELECT*

FROMMedewerkerUren B

WHEREB.Week = A.Week-1

AND SIGN(B.SALDORCNW) <> SIGN(A.SALDORCNW)

and A.JAAR = B.JAAR

and A.PERSNR = B.PERSNR ...

Hello Luis,

Great, that works, thank you.

Cheers,

Julian

Thank you Scott. It is slowly dawning.

The first NOT clause makes all the difference.

Is this T-SQL logic different from say Excel VBA logic?

SUM the turnover of all stores NOT in...

ScottPletcher (2/5/2015)

---

if @IDHuis is not = 'WH' then select the row, and ignore the check on D.AfdelingZPT; but if = 'WH', then also check to see if D.AfdelingZPT <> 'A01'...

Scott thank you.

I can't get my head around it though. 🙂

For one location (@IDHuis = 'WH')

I need to exclude the Hrs from the sum of one department (D.AfdelingZPT =...

Hello pmadhavapeddi22,

Thank you for pointing me in the right direction.

If the condition is not met (@IDHuis='WH') then I need to sum all hours from all D.AfdelingZPT.

So I changed the code...

Thanks.

Thank you.

Cheers,

J.

Got it.

IF @MeeTellen <> 'NEE'

BEGIN

-- HRS VAST

INSERT INTO @T (JAAR, WEEK, AfdelingZPT, HrsVast)

(

SELECTDBO.ISOyear(Begindatum) Jaar, datepart(ISO_WEEK,Begindatum) [Week], AfdelingZPT, sum(DUUR/60.0) HrsVast

FROM DRPDATA

WHERE LocatieCode = @IDHuis

and AfdelingZPT = @IDAfd

AND...

Thank you!

Cheers,

J.

Solved it using Table variables.

DECLARE @T TABLE

(

AfdelingZPT varchar(3) COLLATE database_default ,

Uren Float

) ;

DECLARE @tt TABLE

(

AfdelingZPT varchar(3)...

Thanks. I should be able to figure it out.

A few beers may help (it's evening overhere 😉 )

It seems I need another solution.

FOO returns more rows than FOB.

Thinking of using Temp tables for FOO and FOB, then joining them.

This does not work, one of the CTE's has...

@sqlslacker: Great, thank you, works like a charm! 🙂

I find it difficult to choose the right solution, there seem to be many ways to approach things.

Regards,

Julian