Click here to Skip to main content
15,885,216 members
Home / Discussions / Database
   

Database

 
GeneralRe: Error Pin
Richard Deeming1-Apr-15 0:39
mveRichard Deeming1-Apr-15 0:39 
QuestionConvert msaccess pivot to mssql pivot Pin
kdaras30-Mar-15 22:22
kdaras30-Mar-15 22:22 
AnswerRe: Convert msaccess pivot to mssql pivot Pin
CHill6031-Mar-15 2:44
mveCHill6031-Mar-15 2:44 
GeneralRe: Convert msaccess pivot to mssql pivot Pin
kdaras31-Mar-15 19:45
kdaras31-Mar-15 19:45 
GeneralRe: Convert msaccess pivot to mssql pivot Pin
CHill6031-Mar-15 20:43
mveCHill6031-Mar-15 20:43 
Questionretrieving index info Pin
loyal ginger30-Mar-15 9:39
loyal ginger30-Mar-15 9:39 
AnswerRe: retrieving index info Pin
Sascha Lefèvre30-Mar-15 13:07
professionalSascha Lefèvre30-Mar-15 13:07 
QuestionINSERT from with a loop using MySQL Pin
Jassim Rahma30-Mar-15 4:39
Jassim Rahma30-Mar-15 4: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 22:32
KasGuest29-Mar-15 22:32 
SuggestionRe: Oracle create database error: Error in process: C:\app\...\product\12.1.0\dbhome_1\perl\bin\perl.exe Pin
Kornfeld Eliyahu Peter29-Mar-15 23:43
professionalKornfeld Eliyahu Peter29-Mar-15 23: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 0:34
KasGuest30-Mar-15 0: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 0:57
professionalEddy Vluggen30-Mar-15 0: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 1:29
KasGuest30-Mar-15 1: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 1:39
professionalEddy Vluggen30-Mar-15 1:39 
QuestionGet a single record for each user Pin
Meax25-Mar-15 22:49
Meax25-Mar-15 22:49 
AnswerRe: Get a single record for each user Pin
Afzaal Ahmad Zeeshan25-Mar-15 23:17
professionalAfzaal Ahmad Zeeshan25-Mar-15 23:17 
GeneralRe: Get a single record for each user Pin
Meax25-Mar-15 23:30
Meax25-Mar-15 23:30 
GeneralRe: Get a single record for each user Pin
Afzaal Ahmad Zeeshan25-Mar-15 23:36
professionalAfzaal Ahmad Zeeshan25-Mar-15 23:36 
GeneralRe: Get a single record for each user Pin
Meax25-Mar-15 23:47
Meax25-Mar-15 23:47 
GeneralRe: Get a single record for each user Pin
RUs12326-Mar-15 0:42
RUs12326-Mar-15 0:42 
AnswerRe: Get a single record for each user Pin
Simon_Whale26-Mar-15 1:11
Simon_Whale26-Mar-15 1:11 
AnswerRe: Get a single record for each user Pin
Corporal Agarn26-Mar-15 1:16
professionalCorporal Agarn26-Mar-15 1:16 
AnswerRe: Get a single record for each user Pin
Member 1155935526-Mar-15 20:28
Member 1155935526-Mar-15 20:28 
AnswerRe: Get a single record for each user Pin
Meax3-Apr-15 23:15
Meax3-Apr-15 23:15 
QuestionReason for failing to Drop Column is showing non existent Index Pin
indian14325-Mar-15 8:46
indian14325-Mar-15 8: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.