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 bkrike 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: *

  1. SimonBurrell

    How to calculate time difference past midnight!

    I hope this helps someone when trying to work out how to calculate the time difference when the endtime is the next day. I finally worked it out (thanks to the legendary Dr Bull). /* This returns an output in minutes. If whole hours is the result you want - change the 720 (minutes) to 12...
  2. SimonBurrell

    Update is changing every row in my Table to be the same!

    Hi All I am trying to write a query that (in basic terms) checks if rows in newtable exist in oldtable and if this is true then update oldtable row with new data, else insert data from newtable to oldtable in a new row. I need to update three tables Patient, SSI_Procedure_Detail and...
  3. SimonBurrell

    Update column using counts of other columns??

    Hi All I need to calculate a Risk index that is the sum result of the following for each row in my table: For each ROW... If SSI_ASA > 2 THEN Count 1 ELSE Count 0 If Wound_Cl_ID> 2 THEN Count 1 ELSE Count 0 If Proc_Duration > P_75Percentile THEN Count 1 ELSE Count 0 The result column...
  4. SimonBurrell

    Import multiple MS Access DB's (Data sub-set) to MS SQL 2000

    Hi, I have a requirement to import data from a totally De-normalised MS Access db at 10 remote sites into a normalised central MS SQL server. (From 1 MS Access table to multiple MS SQL tables) The Access db's all have the same schema and have a VB front end. I would like to be able to get the...

Part and Inventory Search

Back
Top