I want to limit a query to a maximum date entered..
I would like to say .. where myDateField = max(mydatefield)
How can I use a function like MAX in a where clause or having clause .. I have tried different sytaxes with no luck. Im sure its easy..I am actually using it in Access but figured it was more of an SQL question
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed