Click here to Skip to main content
15,851,242 members
Home / Discussions / Database
   

Database

 
GeneralRe: large database Pin
Jörgen Andersson20-Jul-15 12:01
professionalJörgen Andersson20-Jul-15 12:01 
AnswerRe: large database Pin
GuyThiebaut18-Jul-15 2:19
professionalGuyThiebaut18-Jul-15 2:19 
GeneralRe: large database Pin
V.18-Jul-15 9:23
professionalV.18-Jul-15 9:23 
GeneralRe: large database Pin
GuyThiebaut18-Jul-15 9:37
professionalGuyThiebaut18-Jul-15 9:37 
QuestionSQL Linq, updating multiple records Pin
jkirkerx15-Jul-15 11:50
professionaljkirkerx15-Jul-15 11:50 
QuestionSave value of PREPARE into a variable Pin
Jassim Rahma14-Jul-15 23:23
Jassim Rahma14-Jul-15 23:23 
AnswerRe: Save value of PREPARE into a variable Pin
Wendelius14-Jul-15 23:45
mentorWendelius14-Jul-15 23:45 
GeneralRe: Save value of PREPARE into a variable Pin
Jassim Rahma15-Jul-15 23:22
Jassim Rahma15-Jul-15 23:22 
I am getting:
Procedure execution failed
1048 - Column 'earned_leave' cannot be null

although the sp_populate_leave_summary returns the correct value as I can see in the result window.

this is the code after adding an OUT:
SQL
WHILE i < total_rows DO
    SET @param_employee_number = (SELECT employee_number FROM earned_leaves LIMIT i,1);

    PREPARE query_statement FROM 'CALL sp_populate_leave_summary(?,?)';
    EXECUTE query_statement USING @param_employee_number, @param_eligible_days;

    UPDATE earned_leaves SET earned_leave = @param_eligible_days WHERE employee_number = @param_employee_number;
    SET i = i + 1;
END WHILE;

my OUT is:
SQL
OUT param_eligible_days int

Technology News @ www.JassimRahma.com

GeneralRe: Save value of PREPARE into a variable Pin
Wendelius15-Jul-15 23:51
mentorWendelius15-Jul-15 23:51 
AnswerRe: Save value of PREPARE into a variable Pin
jschell15-Jul-15 11:45
jschell15-Jul-15 11:45 
QuestionSome help with SQL to Linq Conversions Pin
jkirkerx13-Jul-15 8:04
professionaljkirkerx13-Jul-15 8:04 
AnswerRe: Some help with SQL to Linq Conversions Pin
Richard Deeming13-Jul-15 8:18
mveRichard Deeming13-Jul-15 8:18 
GeneralRe: Some help with SQL to Linq Conversions Pin
jkirkerx13-Jul-15 8:34
professionaljkirkerx13-Jul-15 8:34 
General[Got It] Pin
jkirkerx13-Jul-15 8:58
professionaljkirkerx13-Jul-15 8:58 
GeneralRe: Some help with SQL to Linq Conversions Pin
Richard Deeming13-Jul-15 9:00
mveRichard Deeming13-Jul-15 9:00 
QuestionSQL Linq, query and then take result to query again Pin
jkirkerx10-Jul-15 8:43
professionaljkirkerx10-Jul-15 8:43 
Answer[Solved] Pin
jkirkerx10-Jul-15 9:53
professionaljkirkerx10-Jul-15 9:53 
QuestionSELECT then INSERT data in a matrix way Pin
Farhad Eft9-Jul-15 10:14
Farhad Eft9-Jul-15 10:14 
AnswerRe: SELECT then INSERT data in a matrix way Pin
Richard Deeming9-Jul-15 10:22
mveRichard Deeming9-Jul-15 10:22 
GeneralRe: SELECT then INSERT data in a matrix way Pin
Farhad Eft9-Jul-15 11:51
Farhad Eft9-Jul-15 11:51 
QuestionSQL Linq, concepts of writing queries Pin
jkirkerx8-Jul-15 9:55
professionaljkirkerx8-Jul-15 9:55 
AnswerRe: SQL Linq, concepts of writing queries Pin
Richard Deeming8-Jul-15 11:46
mveRichard Deeming8-Jul-15 11:46 
GeneralRe: SQL Linq, concepts of writing queries Pin
jkirkerx8-Jul-15 13:32
professionaljkirkerx8-Jul-15 13:32 
Questionssrs rendering format ppt pptx Pin
Aurelkb6-Jul-15 0:35
Aurelkb6-Jul-15 0:35 
AnswerRe: ssrs rendering format ppt pptx Pin
Richard MacCutchan6-Jul-15 1:13
mveRichard MacCutchan6-Jul-15 1:13 

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.