Posted by ShastriX on 06/26/06 06:13

Thanks, Erland, but I had no issue running the query in Access 2003 w/o
criteria.

The hitch came up only when I added the "0" criteria on the SessionOff
computed column.

Regards,
Shastri

Erland Sommarskog wrote:
> ShastriX (shastrix@gmail.com) writes:
>
> Then again, this query does not run on SQL Server. (There is no
> date() function in SQL Server and "= False" would yield an error
> about missing column.
>
> Presumably some transformation occurs along the way. You could use
> the Profiler to see what is actually sent to SQL Server.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

[Back to original message]