asked on Total duration
Hi Experts,
I would like to request Experts help. How to make sure column at "TotalDuration" will automatically sum up time value from TimeIN and TimeOUT columns. Attached the print screen of the MSsql table for Experts perusal. Hope Experts will help.
total.png
I would like to request Experts help. How to make sure column at "TotalDuration" will automatically sum up time value from TimeIN and TimeOUT columns. Attached the print screen of the MSsql table for Experts perusal. Hope Experts will help.
total.png
Microsoft SQL Server
Last Comment
Cartillo
Use a trigger on INSERT OR UPDATE, which will update TotalDuration column with the calculated value (sum)
ASKER
Hi RajkumarGS,
How to do this in MSSQL? Please advice
How to do this in MSSQL? Please advice
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Yes. Patrick and acperkins are right.
I also suggest - Instead of using trigger, you can fetch calculated TotalDuration data on demand.
@Cartillo: You may please ignore all my comments in this thread.
Raj
I also suggest - Instead of using trigger, you can fetch calculated TotalDuration data on demand.
@Cartillo: You may please ignore all my comments in this thread.
Raj
ASKER
Hi,
I've revised my sql table, attached the print screen, hope I've followed as per guide..
total1.png
I've revised my sql table, attached the print screen, hope I've followed as per guide..
total1.png
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hi,
Thanks for the guide.
Thanks for the guide.