Search results for query: *

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...

OOPS! Sorry that line should read... ..every row that exists in the SSI_Procedure_details table ends up getting replaced by a single row (duplicated for every existing row). Sorry for the confusion. Simon

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...

Thanks Heaps for that. It didn't occur to me to add the case statements together. Regards Simon

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...

Hi VictoriaJones So it's my turn for the bad day. How did you create the new table with the additional rows? Please advise. Thanks Simon

Thanks SQLSister. Still very messy isn't it. I was hoping that the 'non-technical' users would not have to go into the MS Access db specifically. Simon

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...