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