Click here to Skip to main content
11,705,208 members (52,742 online)
   

Database

 
Questionshow Sum(Balance) as ob on Rows Header and add next rows balance in ob Pin
hadeed147227-Dec-12 6:52
memberhadeed147227-Dec-12 6:52 
AnswerRe: show Sum(Balance) as ob on Rows Header and add next rows balance in ob Pin
djj5527-Dec-12 7:53
memberdjj5527-Dec-12 7:53 
GeneralRe: show Sum(Balance) as ob on Rows Header and add next rows balance in ob Pin
hadeed147227-Dec-12 8:03
memberhadeed147227-Dec-12 8:03 
QuestionSQL BulkCopy using IDataReader - how can you cast the fields? Pin
Allan Watkins26-Dec-12 19:12
memberAllan Watkins26-Dec-12 19:12 
AnswerRe: SQL BulkCopy using IDataReader - how can you cast the fields? Pin
Mycroft Holmes26-Dec-12 20:32
memberMycroft Holmes26-Dec-12 20:32 
GeneralRe: SQL BulkCopy using IDataReader - how can you cast the fields? Pin
AllanW1111127-Dec-12 6:02
memberAllanW1111127-Dec-12 6:02 
AnswerRe: SQL BulkCopy using IDataReader - how can you cast the fields? Pin
PIEBALDconsult27-Dec-12 8:48
memberPIEBALDconsult27-Dec-12 8:48 
QuestionSubquery returns more than 1 row Pin
Jassim Rahma24-Dec-12 1:02
memberJassim Rahma24-Dec-12 1:02 
Hi,

Why I am getting the above error for this stored procedure?

CREATE DEFINER=`root`@`192.168.1.%` PROCEDURE `sp_open_file`(IN param_file_no int, IN param_clinic_id int, IN param_doctor_id int, IN param_account_category int, IN param_account_id int)
BEGIN
    DECLARE param_patient_account_number BIGINT;
    DECLARE param_price_list_id int;
    DECLARE param_account_number BIGINT;
 
    SET param_patient_account_number = (SELECT account_number FROM patients WHERE file_no = param_file_no);
 
    IF (param_account_category  = 1) THEN
        SET param_account_number = param_patient_account_number;
    ELSE
        SET param_account_number = (SELECT account_number FROM accounts WHERE account_id = param_account_id);
    END IF;
 
    SET param_price_list_id = (SELECT price_list_id FROM accounts WHERE account_number = param_account_number);
 
    INSERT INTO visits (file_no, clinic_id, doctor_id, account_category, account_number, price_list_id) VALUES (param_file_no, param_clinic_id, param_doctor_id, param_account_category , param_account_number, param_price_list_id);
    UPDATE patients SET file_is_open = TRUE;
END


Technology News @ www.JassimRahma.com

AnswerRe: Subquery returns more than 1 row Pin
Eddy Vluggen24-Dec-12 1:29
memberEddy Vluggen24-Dec-12 1:29 
AnswerRe: Subquery returns more than 1 row Pin
MaulikDusara24-Dec-12 21:44
memberMaulikDusara24-Dec-12 21:44 
GeneralRe: Subquery returns more than 1 row Pin
Eddy Vluggen25-Dec-12 2:41
memberEddy Vluggen25-Dec-12 2:41 
GeneralRe: Subquery returns more than 1 row Pin
Mycroft Holmes26-Dec-12 11:17
memberMycroft Holmes26-Dec-12 11:17 
GeneralRe: Subquery returns more than 1 row Pin
MaulikDusara26-Dec-12 18:45
memberMaulikDusara26-Dec-12 18:45 
GeneralRe: Subquery returns more than 1 row Pin
Eddy Vluggen27-Dec-12 4:24
memberEddy Vluggen27-Dec-12 4:24 
QuestionOn the Naming of Columns for Lookup tables. Pin
Brady Kelly17-Dec-12 22:44
memberBrady Kelly17-Dec-12 22:44 
AnswerRe: On the Naming of Columns for Lookup tables. Pin
Mycroft Holmes17-Dec-12 23:19
memberMycroft Holmes17-Dec-12 23:19 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Brady Kelly17-Dec-12 23:26
memberBrady Kelly17-Dec-12 23:26 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Mycroft Holmes18-Dec-12 1:11
memberMycroft Holmes18-Dec-12 1:11 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Brady Kelly18-Dec-12 1:15
memberBrady Kelly18-Dec-12 1:15 
AnswerRe: On the Naming of Columns for Lookup tables. Pin
PIEBALDconsult18-Dec-12 4:05
memberPIEBALDconsult18-Dec-12 4:05 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Brady Kelly18-Dec-12 4:12
memberBrady Kelly18-Dec-12 4:12 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
PIEBALDconsult18-Dec-12 4:46
memberPIEBALDconsult18-Dec-12 4:46 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Brady Kelly18-Dec-12 5:34
memberBrady Kelly18-Dec-12 5:34 
QuestionOn Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly14-Dec-12 3:02
memberBrady Kelly14-Dec-12 3:02 
JokeRe: On Strategies to Spell Check the Structure of a Database. Pin
Chris Meech14-Dec-12 4:31
memberChris Meech14-Dec-12 4:31 

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
Web02 | 2.8.150819.1 | Last Updated 26 Aug 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid