In SQL, one cannot use this kind of a where clause, if using multiple values it will have to be a sub query

😎

where Sales.SalesTerritory.[Group] in (@Sales.SalesTerritory.[Group])

should be something like

where Sales.SalesTerritory.[Group] in (select [Group] FROM @Sales.SalesTerritory)