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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: inAwww
  • Content: Threads
  • Order by date
  1. inAwww

    Trigger + Update field with the current date on Update in SQL server

    Hi All, I was wondering if anyone of you has a solution to be able to update 1 single row on a table with a trigger. I am trying to keep track of the modification dates on certain tables. So when someone updates a record it will stamp the current date on the modifydate field. So far, I have only...
  2. inAwww

    Trouble selecting Data between 2 dates in 2 diff Tables in SQL Server

    Hello all, I am wondering if any of you might know what I am doing wrong in my situation. I am Using SQL server 2000 I am trying to count all the records in one table that fall between the date in that one table and a date in a second table. Is that possible to do? so I have something like...
  3. inAwww

    Basic Database Design question. on a Many to many relationship

    Ok, This is going to sound amateurish because it is. I am having issues with a many to many relatioship. Now it is not me having issues but by request of my boss that needs to be convinced. When you create a many to many relatioship you create 3 tables. You populate the 2 outer tables and you...

Part and Inventory Search

Back
Top