Click here to Skip to main content
11,715,160 members (62,939 online)
   

Database

 
QuestionSQL Update Pin
mrfalk29-Jan-13 11:24
membermrfalk29-Jan-13 11:24 
I need some help with an SQL query I’ve been asked to create.

Due to lack of communication, an update was done incorrectly and now needs to be fixed (surprise, surprise Big Grin | :-D ). Each employee has 5 Ben_Codes and the start date for all Ben_Codes needs to be equal to the start date of Ben_Code 1. The dates are not constant so for each employee I need to read Ben_Code 1 record to retrieve start_date and then update Ben_Codes 2 thru 5 with that start_date.

To this point I have done very basic updates using SQL Query and would appreciate any guidance you can provide!!


Emp_id, Ben_Code, start_date
99999 1 10/12/12
99999 2 01/12/13
99999 3 01/12/13
99999 4 01/12/13
99999 5 01/12/13
98989 1 9/15/2012
98989 2 01/12/13
98989 3 01/12/13
98989 4 01/12/13
98989 5 01/12/13
AnswerRe: SQL Update Pin
PIEBALDconsult29-Jan-13 11:47
memberPIEBALDconsult29-Jan-13 11:47 
GeneralRe: SQL Update Pin
mrfalk29-Jan-13 12:07
membermrfalk29-Jan-13 12:07 
AnswerRe: SQL Update Pin
Michael Potter29-Jan-13 11:50
memberMichael Potter29-Jan-13 11:50 
GeneralRe: SQL Update Pin
PIEBALDconsult29-Jan-13 11:59
memberPIEBALDconsult29-Jan-13 11:59 
GeneralRe: SQL Update Pin
Mycroft Holmes29-Jan-13 12:09
memberMycroft Holmes29-Jan-13 12:09 
GeneralRe: SQL Update Pin
mrfalk29-Jan-13 12:17
membermrfalk29-Jan-13 12:17 
GeneralRe: SQL Update Pin
PIEBALDconsult29-Jan-13 12:27
memberPIEBALDconsult29-Jan-13 12:27 
GeneralRe: SQL Update Pin
Mycroft Holmes29-Jan-13 13:49
memberMycroft Holmes29-Jan-13 13:49 
GeneralRe: SQL Update Pin
PIEBALDconsult29-Jan-13 12:20
memberPIEBALDconsult29-Jan-13 12:20 
GeneralRe: SQL Update Pin
Mycroft Holmes29-Jan-13 13:54
memberMycroft Holmes29-Jan-13 13:54 
GeneralRe: SQL Update Pin
jschell29-Jan-13 14:13
memberjschell29-Jan-13 14:13 
GeneralRe: SQL Update Pin
Michael Potter30-Jan-13 4:28
memberMichael Potter30-Jan-13 4:28 
GeneralRe: SQL Update Pin
PIEBALDconsult30-Jan-13 5:05
memberPIEBALDconsult30-Jan-13 5:05 
GeneralRe: SQL Update Pin
jschell30-Jan-13 7:58
memberjschell30-Jan-13 7:58 
GeneralRe: SQL Update Pin
PIEBALDconsult30-Jan-13 8:40
memberPIEBALDconsult30-Jan-13 8:40 
GeneralRe: SQL Update Pin
Michael Potter31-Jan-13 3:57
memberMichael Potter31-Jan-13 3:57 
GeneralRe: SQL Update Pin
PIEBALDconsult31-Jan-13 4:05
memberPIEBALDconsult31-Jan-13 4:05 
GeneralRe: SQL Update Pin
jschell31-Jan-13 8:01
memberjschell31-Jan-13 8:01 
AnswerRe: SQL Update Pin
PIEBALDconsult29-Jan-13 13:22
memberPIEBALDconsult29-Jan-13 13:22 
AnswerRe: SQL Update Pin
Jörgen Andersson30-Jan-13 1:21
memberJörgen Andersson30-Jan-13 1:21 
AnswerRe: SQL Update Pin
mrfalk30-Jan-13 6:20
membermrfalk30-Jan-13 6:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.150901.1 | Last Updated 2 Sep 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid