troubleshooting Question

SQL Table

Avatar of phman1275
phman1275 asked on
ComponentsSQL
3 Comments1 Solution177 ViewsLast Modified:
Hi, I need some help about trigger and calculation field. I am thinking set a Status field as a calculation field on the Components table. This field will show either "Ready", "Usable", "Not-Ready" depends on the score on the Inspection table. If greater 90 then consider "Ready", below 90 but above 75 then consider "Usable" otherwise "Not-Ready". I think I need the trigger to do that but I have no clue.

Here are the tables:

Components
ComponentID, Version, OwnerID,  Status
1                        A11        100           Ready
2                        B23        200           Usable

Insepctions
ComponentID, Date,            Score
1                        1/3/2016     95
2                        2/13/2017   55
                          2/15/2017   65
                          2/17/2017   80

*** The third inspection result will reflect on Components table with the status "Usable".

Thanks
ASKER CERTIFIED SOLUTION
ste5an
Senior Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros