Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by hockEdeals
-
How do I query for records older than 3 months to the day?
lol, that's was right i just didn't know how to write it as a select statement with where. Sorry, that's exactly what i needed. THANKS SQLBILL & CHECKAI!- hockEdeals
- Post #6
- Forum: Microsoft SQL Server: Programming
-
How do I query for records older than 3 months to the day?
In the end i want to automatically delete all entries older than 3 months. They are users who are inactive. The field is called LastLoginDate and i'm using GetDate() to store it initially whenever the user logs on, it will update. I want to be able to click a button and run a delete where...- hockEdeals
- Post #3
- Forum: Microsoft SQL Server: Programming
-
How do I query for records older than 3 months to the day?
How do i select items in my database older than 3 months. I'm using getdate() to store it when it's created and i want to query items that are older than 3 monts. I'm using smalldatetime in the field.- hockEdeals
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
