| Author |
 Topic  |
|
|
105ben
Starting Member
United Kingdom
16 Posts |
 Posted - 01/03/2013 : 09:25:05
|
Hello,
I need the following code to update payscale to 2 for every person has has been assigned to a staff role for over 5 years. I'm getting an #1064 error for the DATEADD part.
update person as p, staff_role_allocation as sra
set payscale = '2'
where p.person_id = sra.person_id and sra.start_date <= DATEADD(yy, -5, GETDATE())
can anybody see why? |
|
|
nigelrivett
Flowing Fount of Yak Knowledge
United Kingdom
3328 Posts |
Posted - 01/03/2013 : 09:29:43
|
update person
set payscale = '2'
from person as p
join staff_role_allocation as sra
on p.person_id = sra.person_id
and sra.start_date <= DATEADD(yy, -5, GETDATE())
==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy. |
 |
|
|
105ben
Starting Member
United Kingdom
16 Posts |
Posted - 01/03/2013 : 09:34:54
|
| That gives me a #1064 again, this time on the From line.. Had tried this code previously too |
|
|
|
nigelrivett
Flowing Fount of Yak Knowledge
United Kingdom
3328 Posts |
Posted - 01/03/2013 : 09:40:35
|
Are you using sql server?
I suspect MySQL
==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy. |
Edited by - nigelrivett on 01/03/2013 09:41:56 |
|
|
|
105ben
Starting Member
United Kingdom
16 Posts |
Posted - 01/03/2013 : 09:41:54
|
| not 100% sure to be honest :S Im using php MyAdmin, is that using SQL server (probably a stupid question I know) |
|
|
|
105ben
Starting Member
United Kingdom
16 Posts |
Posted - 01/03/2013 : 09:44:38
|
| Ignore that then, yes it's MySQL |
|
|
|
madhivanan
Premature Yak Congratulator
India
22461 Posts |
Posted - 01/07/2013 : 08:25:44
|
Try this
update person as p, staff_role_allocation as sra
set payscale = '2'
where p.person_id = sra.person_id and sra.start_date <= DATE_ADD(now(), interval -5 year)
Madhivanan
Failing to plan is Planning to fail |
Edited by - madhivanan on 01/07/2013 08:27:00 |
|
|
| |
Topic |
|
Date Calculation Query
