TSQL - proper query

Eyeballeth the below

Select 1
From v_NAsInvoiceItem Inv
Where Item.ShipToContact = Inv.ShiptoContact And Max(Inv.Expiration) = Year(@Date2)
Group By Expiration

You can't use an aggregate such as MAX, SUM, COUNT, etc. in a WHERE clause, hence the error.
That needs to go in the HAVING clause, which allows filtering based on aggregates.

Also, what's the purpose for both GROUP BY and MAX on column Expiration?

For more info check out my article SQL Server GROUP BY Solutions

Your query has multiple problems.  

First in the select you need: Select 1 Max(Inv.Expiration) plus another field to group by.  
Second Group by Expiration does not make sense when you are using that field in the max calculation.  
Third in the where clause there is the "item" table that has not be declared in this query.  
Fourth all you need to do is move the Max(Inv.Expiration) = Year(@Date2) into a Having statement which goes after the Group by statement.

Ok,

So now I have this:

Declare
@Date2 AS Date = '12/31/2015'
SELECT 
		Item.[Description] + ' in print' AS Description,
		YEAR((Item.Expiration)) AS Year,
		2 AS SRT1, 1 AS SRT2, Item.Code2 AS SRT3
		,ShipToContact
From v_NAsInvoiceItem Item INNER JOIN
				tblNAsProgramCodes ON Item.ProgramCodeID = tblNAsProgramCodes.ProgramCode
	WHERE    FormatCode = 'Subs' AND Item.Code1 = 'JOURNAL' --And Year(Item.Expiration) = Year(@Date2)
		--And Not Exists
		--	( Select 1 From tblNAsAffiliations mem Where Item.ShipToContact = Mem.Contact1 And  Mem.Date2 >= GetDate())
		And Exists
			(Select Max([Expiration]), ShiptoContact From v_NAsInvoiceItem Inv Where Item.ShipToContact = Inv.ShiptoContact Group By ShiptoContact Having Max(Year(Inv.Expiration)) = Year(@Date2) )
			Order By ShipToContact

Select allOpen in new window

But am getting this:

Year	SRT1	SRT2	SRT3	ShipToContact
1994	   2	           1	           IS	           1000
1995	2	1	IS	1000
1996	2	1	IS	1000
1997	2	1	IS	1000
1998	2	1	IS	1000
1999	2	1	IS	1000
2007	2	1	CS	1000
2007	2	1	IS	1000
2008	2	1	CS	1000
2008	2	1	IS	1000
2009	2	1	CS	1000
2009	2	1	IS	1000
2006	2	1	CS	1000

Select allOpen in new window

When the year should only be 2015

Please help and thanks

>--And Year(Item.Expiration) = Year(@Date2)
That's likely because you commented out ( -- ) the part of the WHERE clause that filters by year.

What are you trying to accomplish with this query?

Amour22015, do you still need help with this query?

Thanks great..