I am in the process of upsizing a MS Access application to a Access FE and
SQL BE. (MS Access 2007 SQL2005)
I used the MS upsize wizard to convert all the tables to SQL format.
I have been going through the application and updating the linked tables to

In VBA the following will yeild the last day of the current month:
dtmLDM = DateSerial(Year(Date), Month(Date) + 1, 0)
How can you accomplish the same thing in T-SQL?
Patrick

Originally I had 2 tables in my DB, [Property] and [Employee].
Each employee can have 1 "Home Property" so the employee table has a
HomePropertyID FK field to Property.
Later I needed to model the situation where despite having only 1