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!

Register Log in
  • Congratulations derfloh 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 inAwww

  1. inAwww

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

    Yeah, Thanks Rob, I actually found the timestamp binary deal the hard way, after I had created all the tables with a timestamp field in them. Angel's code though worked great. thanks so much. I will have to create a different trigger for each table as they obviously have different keys etc. But...
  2. 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...
  3. inAwww

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

    THank you, tlbroadbent. Your example totally set my mind to what to look for and helped me figure out what to do to get the data I need.
  4. inAwww

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

    Well, I got rid of Active in one of the tables (the one that really does not need it) and it does count now but.. it takes into account all the dates in one of the tables. Is there a way to just make SQL take into account the very last record of a table or the last 2 records? and then compare...
  5. 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...
  6. inAwww

    Basic Database Design question. on a Many to many relationship

    Thanks so much. :)
  7. 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...
See more

Part and Inventory Search

Back
Top