Posted by rabkin on 01/25/06 09:32

Hugo Kornelis wrote:
> There's comp.databases.ms-access. And over 20 groups in the
> microsoft.public.access hierarchy. There are also access groups in many
> international hierarchies, or in international sub-hierarchies of the
> microsoft.public hierarchy.

Thank you. Sorry my ISP seems not to offer them.

> Don't count on it - there are many major differences between Jet SQL
> (used in Access) and Trasact SQL (used in SQL Server). T-SQL tends to be
> a lot closer to the ANSI-defined SQL standards.
>

Good to know.

> >
> >Where is the missing parameter? I think it's something to do with the
> >LEFT JOIN, but I'm not sure - I'm a SQL newbie.
>
> According to the error message, two parameters where expected in EXEC.
> The code you posted does not contain the word "EXEC". Maybe you should
> double-check if the error is not produced by another part of your code?

Nope, all my error messages end with a period and "in EXEC". I'm pretty
sure it's that line - although I'm getting the same problem elsewhere

> Anyway, the query you posted passes the syntax check of SQL Server 2000
> without problems.
>

Thanks for checking.

> --
> Hugo Kornelis, SQL Server MVP

--Max

[Back to original message]