Click here to Skip to main content
15,557,928 members
Home / Discussions / Database
   

Database

 
GeneralRe: Error Pin
Richard Deeming1-Apr-15 1:39
mveRichard Deeming1-Apr-15 1:39 
QuestionConvert msaccess pivot to mssql pivot Pin
kdaras30-Mar-15 23:22
kdaras30-Mar-15 23:22 
AnswerRe: Convert msaccess pivot to mssql pivot Pin
CHill6031-Mar-15 3:44
mveCHill6031-Mar-15 3:44 
GeneralRe: Convert msaccess pivot to mssql pivot Pin
kdaras31-Mar-15 20:45
kdaras31-Mar-15 20:45 
GeneralRe: Convert msaccess pivot to mssql pivot Pin
CHill6031-Mar-15 21:43
mveCHill6031-Mar-15 21:43 
Questionretrieving index info Pin
loyal ginger30-Mar-15 10:39
loyal ginger30-Mar-15 10:39 
AnswerRe: retrieving index info Pin
Sascha Lefèvre30-Mar-15 14:07
professionalSascha Lefèvre30-Mar-15 14:07 
QuestionINSERT from with a loop using MySQL Pin
Jassim Rahma30-Mar-15 5:39
Jassim Rahma30-Mar-15 5:39 
Hi,

I have employee_benefits MySQL table with the following fields:

employee_benefit_id --- autonumber
employee_id
benefit_category
benefit_description
benefit_amount


I want to loop through all records in the above table and insert the values into salary_slips table which has the following fields:

salary_slip_id --- autonumber
document_id ---- forget this it's just UUID
employee_id -- from employee_id in employee_benefits
slip_month -- from SP variable param_slip_month
slip_year -- from SP variable param_slip_year


and then I want to insert data into salary_slips_details:

salary_slip_details_id --- autonumber
salary_slip_id  -- the id from salary_slips table
slip_details_description -- benefit_description from employee_benefits table
slip_details_amount -- benefit_amount from employee_benefits table


How can I do this complicated query please?


Thanks,
Jassim


Technology News @ www.JassimRahma.com

QuestionOracle create database error: Error in process: C:\app\...\product\12.1.0\dbhome_1\perl\bin\perl.exe Pin
KasGuest29-Mar-15 23:32
KasGuest29-Mar-15 23:32 
SuggestionRe: Oracle create database error: Error in process: C:\app\...\product\12.1.0\dbhome_1\perl\bin\perl.exe Pin
Kornfeld Eliyahu Peter30-Mar-15 0:43
professionalKornfeld Eliyahu Peter30-Mar-15 0:43 
GeneralRe: Oracle create database error: Error in process: C:\app\...\product\12.1.0\dbhome_1\perl\bin\perl.exe Pin
KasGuest30-Mar-15 1:34
KasGuest30-Mar-15 1:34 
AnswerRe: Oracle create database error: Error in process: C:\app\...\product\12.1.0\dbhome_1\perl\bin\perl.exe Pin
Eddy Vluggen30-Mar-15 1:57
professionalEddy Vluggen30-Mar-15 1:57 
GeneralRe: Oracle create database error: Error in process: C:\app\...\product\12.1.0\dbhome_1\perl\bin\perl.exe Pin
KasGuest30-Mar-15 2:29
KasGuest30-Mar-15 2:29 
GeneralRe: Oracle create database error: Error in process: C:\app\...\product\12.1.0\dbhome_1\perl\bin\perl.exe Pin
Eddy Vluggen30-Mar-15 2:39
professionalEddy Vluggen30-Mar-15 2:39 
QuestionGet a single record for each user Pin
Meax25-Mar-15 23:49
Meax25-Mar-15 23:49 
AnswerRe: Get a single record for each user Pin
Afzaal Ahmad Zeeshan26-Mar-15 0:17
mveAfzaal Ahmad Zeeshan26-Mar-15 0:17 
GeneralRe: Get a single record for each user Pin
Meax26-Mar-15 0:30
Meax26-Mar-15 0:30 
GeneralRe: Get a single record for each user Pin
Afzaal Ahmad Zeeshan26-Mar-15 0:36
mveAfzaal Ahmad Zeeshan26-Mar-15 0:36 
GeneralRe: Get a single record for each user Pin
Meax26-Mar-15 0:47
Meax26-Mar-15 0:47 
GeneralRe: Get a single record for each user Pin
RUs12326-Mar-15 1:42
RUs12326-Mar-15 1:42 
AnswerRe: Get a single record for each user Pin
Simon_Whale26-Mar-15 2:11
Simon_Whale26-Mar-15 2:11 
AnswerRe: Get a single record for each user Pin
Corporal Agarn26-Mar-15 2:16
professionalCorporal Agarn26-Mar-15 2:16 
AnswerRe: Get a single record for each user Pin
Member 1155935526-Mar-15 21:28
Member 1155935526-Mar-15 21:28 
AnswerRe: Get a single record for each user Pin
Meax4-Apr-15 0:15
Meax4-Apr-15 0:15 
QuestionReason for failing to Drop Column is showing non existent Index Pin
indian14325-Mar-15 9:46
indian14325-Mar-15 9:46 

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.