Forum Discussion
Solved
DataSource.Error: Microsoft SQL: Must declare the scalar variable
Hi everybody,
I get this error message in PowerQuery "DataSource.Error: Microsoft SQL: Must declare the scalar variable @Jaar" In these lines of code. The issue seems to be Year(start)=@jaar.
Does anybody know how to solve this?
SELECT
Academy
,Soort
,EvenementID
,Start
,Omzet
,AantalDagen
,Trainer
,PercentageMarketingKosten/100 * Omzet as Marketingkosten
,LocatieBerekend
,Locatie
,CommissieVergoeding
,Commissie
,Omzet
- PercentageMarketingKosten/100 * Omzet
- Trainer
- Locatie
- Commissie
as Brutomarge
,Overig
FROM tl.v_Projectadministratie
WHERE OmzetLaptops=0
and Year(start)=@Jaar
and Trainer<>0
AND Start<= GETDATE()-30
ORDER BY Start DESC
Exactly as the error message says - you need to provide the value of that variable, or replace it with a static value.
1 Reply
Exactly as the error message says - you need to provide the value of that variable, or replace it with a static value.