Click here to Skip to main content
15,867,488 members
Home / Discussions / Database
   

Database

 
AnswerRe: Book recommendation for learning SQL Pin
gvprabu20-Feb-13 23:09
gvprabu20-Feb-13 23:09 
QuestionCan we delete old records from aspstatetempsessions table? Pin
manikantaer29-Jan-13 17:43
manikantaer29-Jan-13 17:43 
AnswerRe: Can we delete old records from aspstatetempsessions table? Pin
thatraja4-Oct-13 20:46
professionalthatraja4-Oct-13 20:46 
Questioncontrol AVG cost and close stock Pin
kornkimhour29-Jan-13 15:13
kornkimhour29-Jan-13 15:13 
AnswerRe: control AVG cost and close stock Pin
thatraja4-Oct-13 20:50
professionalthatraja4-Oct-13 20:50 
QuestionMySQL Table Lock Question Pin
Richard Andrew x6429-Jan-13 12:46
professionalRichard Andrew x6429-Jan-13 12:46 
AnswerRe: MySQL Table Lock Question Pin
Jörgen Andersson30-Jan-13 10:34
professionalJörgen Andersson30-Jan-13 10:34 
QuestionSQL Update Pin
mrfalk29-Jan-13 11:24
mrfalk29-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
mvePIEBALDconsult29-Jan-13 11:47 
GeneralRe: SQL Update Pin
mrfalk29-Jan-13 12:07
mrfalk29-Jan-13 12:07 
AnswerRe: SQL Update Pin
Michael Potter29-Jan-13 11:50
Michael Potter29-Jan-13 11:50 
GeneralRe: SQL Update Pin
PIEBALDconsult29-Jan-13 11:59
mvePIEBALDconsult29-Jan-13 11:59 
GeneralRe: SQL Update Pin
Mycroft Holmes29-Jan-13 12:09
professionalMycroft Holmes29-Jan-13 12:09 
GeneralRe: SQL Update Pin
mrfalk29-Jan-13 12:17
mrfalk29-Jan-13 12:17 
GeneralRe: SQL Update Pin
PIEBALDconsult29-Jan-13 12:27
mvePIEBALDconsult29-Jan-13 12:27 
GeneralRe: SQL Update Pin
Mycroft Holmes29-Jan-13 13:49
professionalMycroft Holmes29-Jan-13 13:49 
GeneralRe: SQL Update Pin
PIEBALDconsult29-Jan-13 12:20
mvePIEBALDconsult29-Jan-13 12:20 
GeneralRe: SQL Update Pin
Mycroft Holmes29-Jan-13 13:54
professionalMycroft Holmes29-Jan-13 13:54 
GeneralRe: SQL Update Pin
jschell29-Jan-13 14:13
jschell29-Jan-13 14:13 
GeneralRe: SQL Update Pin
Michael Potter30-Jan-13 4:28
Michael Potter30-Jan-13 4:28 
GeneralRe: SQL Update Pin
PIEBALDconsult30-Jan-13 5:05
mvePIEBALDconsult30-Jan-13 5:05 
GeneralRe: SQL Update Pin
jschell30-Jan-13 7:58
jschell30-Jan-13 7:58 
GeneralRe: SQL Update Pin
PIEBALDconsult30-Jan-13 8:40
mvePIEBALDconsult30-Jan-13 8:40 
GeneralRe: SQL Update Pin
Michael Potter31-Jan-13 3:57
Michael Potter31-Jan-13 3:57 
GeneralRe: SQL Update Pin
PIEBALDconsult31-Jan-13 4:05
mvePIEBALDconsult31-Jan-13 4:05 

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

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