> From: Claude Schneegans
> I'm not too familiar with MSSQL, can someone tell me what
> would be the equivalent for the line "page2.dateMaj >
> page1.dateMaj AS modif" and possibly an alternative that
> would work in both cases?
What's it meant to return?
I presume you want to have it so that it returns 1 or true when
page2.dateMaj is greater than page1.dateMaj
CASE page2.dateMaj > page1.dateMaj THEN '1' ELSE '0' END AS modif
Note that you can put whatever you want in place of the '1' and '0'
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- Compatibility problem bet. Access and MSSQL Claude Schneegans
- Re: Compatibility problem bet. Access and MSSQL Philip Arnold
- Re: Compatibility problem bet. Access and MSSQL Claude Schneegans
- RE: Compatibility problem bet. Access and M... Philip Arnold
- RE: Compatibility problem bet. Access a... Jochem van Dieten
- RE: Compatibility problem bet. Acc... Jochem van Dieten
- RE: Compatibility problem bet. Acc... Philip Arnold
- RE: Compatibility problem bet.... Jochem van Dieten
- Re: Compatibility problem bet. Access and MSSQL Claude Schneegans