Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Exam Updates?????

Author  Topic 

Amberrosereynolds
Starting Member

9 Posts

Posted - 2012-01-17 : 05:55:18


Hello!

My company have created a website where employees will be able to take a test to earn points (CPD hours) which will be updated every time an employee takes the test.

I am trying to find a way to update the number of CPD hours each employee has earned by using SQL, and displaying this on their profile page.

The number of CPD hours awarded will need to be updated every time they earn more points. Every time they take the test, 2 CPD hours will be added.

Any help on this would be much appreciated! :) Thanks!

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-01-17 : 06:31:50
Unless you want people's random guesses, please post your table structure at the very least.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -