Finally Crossed Over ...

Good morning (or afternoon, depending on your local).

I've finally crossed over from Access to SQL Server. An interesting step fraught with surprises, syntax quirks and occasionally some exclamations of joy (just kidding).

Anyway, here's my first question. I'm working on moving a currently functioning VB app from an Access backend to a SQL Server back end. In the process, I have been converting my app driven SQL calls to Server based stored procedures. Aside from a few issues (like SQL not liking concatenating string with the &), everything has worked out until this gem:
SET NOCOUNT ON
TRANSFORM Max(tE.EntryKey) AS Expr1
SELECT tE.ProjectKey
FROM TS_tblWeeks tW
INNER JOIN (TS_tblProjects tP
INNER JOIN (TS_qryGroup tG
INNER JOIN TS_tblEntry tE
ON tG.GroupKey = tE.GroupKey)
ON tP.ProjectKey = tE.ProjectKey)
ON tW.WeekKey = tE.WeekKey
WHERE (tE.WeekKey) = 1 And (tE.PersonKey) = 1
GROUP BY tW.WeekKey, tE.ProjectKey, tP.ProjectSort
ORDER BY tW.WeekKey, tP.ProjectSort, tG.GroupKey
PIVOT tG.GroupKey;
SQL server reports:Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'tE'.
Msg 156, Level 15, State 1, Line 13
Incorrect syntax near the keyword 'PIVOT'.
The highlighted lines are the TRANSFORM and PIVOT lines.

The query works fine in Access, and works fine through ADO.NET as a supplied query. My intention is to make the two integers in the WHERE clause to be parameters supplied to the procedure.

It's something simple, isn't it?

Thanks!