Click here to Skip to main content
13,259,194 members (49,694 online)
   

Database

 
GeneralRe: Database design question Pin
jschell30-Dec-12 9:28
memberjschell30-Dec-12 9:28 
AnswerRe: Database design question Pin
Mycroft Holmes28-Dec-12 12:05
memberMycroft Holmes28-Dec-12 12:05 
QuestionImporting of Huge fixed width text file in sql server table Pin
ibrahim sharief27-Dec-12 10:24
memberibrahim sharief27-Dec-12 10:24 
AnswerRe: Importing of Huge fixed width text file in sql server table Pin
PIEBALDconsult27-Dec-12 15:08
memberPIEBALDconsult27-Dec-12 15:08 
AnswerRe: Importing of Huge fixed width text file in sql server table Pin
Deepak Kr130-Dec-12 21:29
memberDeepak Kr130-Dec-12 21:29 
AnswerRe: Importing of Huge fixed width text file in sql server table Pin
jschell31-Dec-12 10:14
memberjschell31-Dec-12 10:14 
Questionshow Sum(Balance) as ob on Rows Header and add next rows balance in ob Pin
hadeed147227-Dec-12 7:52
memberhadeed147227-Dec-12 7:52 
AnswerRe: show Sum(Balance) as ob on Rows Header and add next rows balance in ob Pin
djj5527-Dec-12 8:53
memberdjj5527-Dec-12 8:53 
GeneralRe: show Sum(Balance) as ob on Rows Header and add next rows balance in ob Pin
hadeed147227-Dec-12 9:03
memberhadeed147227-Dec-12 9:03 
QuestionSQL BulkCopy using IDataReader - how can you cast the fields? Pin
Allan Watkins26-Dec-12 20:12
memberAllan Watkins26-Dec-12 20:12 
AnswerRe: SQL BulkCopy using IDataReader - how can you cast the fields? Pin
Mycroft Holmes26-Dec-12 21:32
memberMycroft Holmes26-Dec-12 21:32 
GeneralRe: SQL BulkCopy using IDataReader - how can you cast the fields? Pin
AllanW1111127-Dec-12 7:02
memberAllanW1111127-Dec-12 7:02 
AnswerRe: SQL BulkCopy using IDataReader - how can you cast the fields? Pin
PIEBALDconsult27-Dec-12 9:48
memberPIEBALDconsult27-Dec-12 9:48 
QuestionSubquery returns more than 1 row Pin
Jassim Rahma24-Dec-12 2:02
memberJassim Rahma24-Dec-12 2: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 2:29
memberEddy Vluggen24-Dec-12 2:29 
AnswerRe: Subquery returns more than 1 row Pin
MaulikDusara24-Dec-12 22:44
memberMaulikDusara24-Dec-12 22:44 
GeneralRe: Subquery returns more than 1 row Pin
Eddy Vluggen25-Dec-12 3:41
memberEddy Vluggen25-Dec-12 3:41 
GeneralRe: Subquery returns more than 1 row Pin
Mycroft Holmes26-Dec-12 12:17
memberMycroft Holmes26-Dec-12 12:17 
GeneralRe: Subquery returns more than 1 row Pin
MaulikDusara26-Dec-12 19:45
memberMaulikDusara26-Dec-12 19:45 
GeneralRe: Subquery returns more than 1 row Pin
Eddy Vluggen27-Dec-12 5:24
memberEddy Vluggen27-Dec-12 5:24 
QuestionOn the Naming of Columns for Lookup tables. Pin
Brady Kelly17-Dec-12 23:44
memberBrady Kelly17-Dec-12 23:44 
AnswerRe: On the Naming of Columns for Lookup tables. Pin
Mycroft Holmes18-Dec-12 0:19
memberMycroft Holmes18-Dec-12 0:19 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Brady Kelly18-Dec-12 0:26
memberBrady Kelly18-Dec-12 0:26 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Mycroft Holmes18-Dec-12 2:11
memberMycroft Holmes18-Dec-12 2:11 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Brady Kelly18-Dec-12 2:15
memberBrady Kelly18-Dec-12 2:15 
AnswerRe: On the Naming of Columns for Lookup tables. Pin
PIEBALDconsult18-Dec-12 5:05
memberPIEBALDconsult18-Dec-12 5:05 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Brady Kelly18-Dec-12 5:12
memberBrady Kelly18-Dec-12 5:12 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
PIEBALDconsult18-Dec-12 5:46
memberPIEBALDconsult18-Dec-12 5:46 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Brady Kelly18-Dec-12 6:34
memberBrady Kelly18-Dec-12 6:34 
QuestionOn Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly14-Dec-12 4:02
memberBrady Kelly14-Dec-12 4:02 
JokeRe: On Strategies to Spell Check the Structure of a Database. Pin
Chris Meech14-Dec-12 5:31
memberChris Meech14-Dec-12 5:31 
AnswerRe: On Strategies to Spell Check the Structure of a Database. Pin
Simon_Whale14-Dec-12 5:52
memberSimon_Whale14-Dec-12 5:52 
AnswerRe: On Strategies to Spell Check the Structure of a Database. Pin
Mycroft Holmes14-Dec-12 14:12
memberMycroft Holmes14-Dec-12 14:12 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly14-Dec-12 17:36
memberBrady Kelly14-Dec-12 17:36 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Mycroft Holmes14-Dec-12 17:57
memberMycroft Holmes14-Dec-12 17:57 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly14-Dec-12 18:12
memberBrady Kelly14-Dec-12 18:12 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Mycroft Holmes14-Dec-12 22:13
memberMycroft Holmes14-Dec-12 22:13 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly14-Dec-12 22:25
memberBrady Kelly14-Dec-12 22:25 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
PIEBALDconsult15-Dec-12 9:49
memberPIEBALDconsult15-Dec-12 9:49 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly15-Dec-12 19:12
memberBrady Kelly15-Dec-12 19:12 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
PIEBALDconsult18-Dec-12 11:47
memberPIEBALDconsult18-Dec-12 11:47 
GeneralRe: On Strategies to Spell Check the Structure of a Database. Pin
Brady Kelly18-Dec-12 12:01
memberBrady Kelly18-Dec-12 12:01 
Questionsending images from a SQL database to a user's email as attachment Pin
Member 946798213-Dec-12 3:16
memberMember 946798213-Dec-12 3:16 
QuestionRe: sending images from a SQL database to a user's email as attachment Pin
Eddy Vluggen13-Dec-12 3:29
memberEddy Vluggen13-Dec-12 3:29 
QuestionODBC Returns Wrong Data Pin
GenJerDan12-Dec-12 6:23
memberGenJerDan12-Dec-12 6:23 
AnswerRe: ODBC Returns Wrong Data Pin
Chris Meech12-Dec-12 6:50
memberChris Meech12-Dec-12 6:50 
GeneralRe: ODBC Returns Wrong Data Pin
GenJerDan12-Dec-12 7:20
memberGenJerDan12-Dec-12 7:20 
GeneralRe: ODBC Returns Wrong Data Pin
Chris Meech12-Dec-12 7:28
memberChris Meech12-Dec-12 7:28 
AnswerRe: ODBC Returns Wrong Data Pin
PIEBALDconsult12-Dec-12 7:28
memberPIEBALDconsult12-Dec-12 7:28 
GeneralRe: ODBC Returns Wrong Data Pin
GenJerDan12-Dec-12 8:18
memberGenJerDan12-Dec-12 8:18 

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.


Advertise | Privacy |
Web02 | 2.8.171114.1 | Last Updated 23 Nov 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid