Click here to Skip to main content
       

Database

 
AnswerRe: Book recommendation for learning SQL Pinmembergvprabu20-Feb-13 23:09 
QuestionCan we delete old records from aspstatetempsessions table? Pinmembermanikantaer29-Jan-13 17:43 
AnswerRe: Can we delete old records from aspstatetempsessions table? Pinmvpthatraja4-Oct-13 20:46 
Questioncontrol AVG cost and close stock Pinmemberkornkimhour29-Jan-13 15:13 
AnswerRe: control AVG cost and close stock Pinmvpthatraja4-Oct-13 20:50 
QuestionMySQL Table Lock Question PinmemberRichard Andrew x6429-Jan-13 12:46 
AnswerRe: MySQL Table Lock Question PinmemberJörgen Andersson30-Jan-13 10:34 
QuestionSQL Update Pinmembermrfalk29-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 PinmemberPIEBALDconsult29-Jan-13 11:47 
GeneralRe: SQL Update Pinmembermrfalk29-Jan-13 12:07 
AnswerRe: SQL Update PinmemberMichael Potter29-Jan-13 11:50 
GeneralRe: SQL Update PinmemberPIEBALDconsult29-Jan-13 11:59 
GeneralRe: SQL Update PinmemberMycroft Holmes29-Jan-13 12:09 
GeneralRe: SQL Update Pinmembermrfalk29-Jan-13 12:17 
GeneralRe: SQL Update PinmemberPIEBALDconsult29-Jan-13 12:27 
GeneralRe: SQL Update PinmemberMycroft Holmes29-Jan-13 13:49 
GeneralRe: SQL Update PinmemberPIEBALDconsult29-Jan-13 12:20 
GeneralRe: SQL Update PinmemberMycroft Holmes29-Jan-13 13:54 
GeneralRe: SQL Update Pinmemberjschell29-Jan-13 14:13 
GeneralRe: SQL Update PinmemberMichael Potter30-Jan-13 4:28 
GeneralRe: SQL Update PinmemberPIEBALDconsult30-Jan-13 5:05 
GeneralRe: SQL Update Pinmemberjschell30-Jan-13 7:58 
GeneralRe: SQL Update PinmemberPIEBALDconsult30-Jan-13 8:40 
GeneralRe: SQL Update PinmemberMichael Potter31-Jan-13 3:57 
GeneralRe: SQL Update PinmemberPIEBALDconsult31-Jan-13 4:05 

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
Web01 | 2.8.140814.1 | Last Updated 15 Aug 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid