Click here to Skip to main content
15,944,136 members
Home / Discussions / Database
   

Database

 
GeneralRe: System.Data.SqlClient.SqlException: Procedure or function 'StaffSearch_sel' expects parameter '@TotalRows', which was not supplied. Pin
indian1437-Apr-15 19:59
indian1437-Apr-15 19:59 
GeneralRe: System.Data.SqlClient.SqlException: Procedure or function 'StaffSearch_sel' expects parameter '@TotalRows', which was not supplied. Pin
Sascha Lefèvre7-Apr-15 20:54
professionalSascha Lefèvre7-Apr-15 20:54 
QuestionA data source instance has not been supplied for the data source Pin
indian1436-Apr-15 12:55
indian1436-Apr-15 12:55 
QuestionHow Do I Insert Only Recently Updated Row From Table1 To 2 in MySQL Pin
RevathySanthanam2-Apr-15 4:10
RevathySanthanam2-Apr-15 4:10 
Rant[REPOST] How Do I Insert Only Recently Updated Row From Table1 To 2 in MySQL Pin
Richard Deeming2-Apr-15 4:41
mveRichard Deeming2-Apr-15 4:41 
Questionmultiple joins, works in sql manager but not in asp.net Pin
jkirkerx1-Apr-15 12:47
professionaljkirkerx1-Apr-15 12:47 
Answer[solved] Pin
jkirkerx1-Apr-15 13:02
professionaljkirkerx1-Apr-15 13:02 
SuggestionRe: multiple joins, works in sql manager but not in asp.net Pin
Richard Deeming2-Apr-15 2:30
mveRichard Deeming2-Apr-15 2:30 
Those JOINs don't look right. Try:
SQL
FROM
    COMPLETEDORDERS co
    LEFT JOIN CUSTOMER_BILLING_ADDRESS ba ON co.BA_ID = ba.BA_ID    -- I'm guessing the ID column for ba and sa;
    LEFT JOIN CUSTOMER_SHIPPING_ADDRESS sa ON co.SA_ID = sa.SA_ID   -- change them to the correct column names.

You've also got five queries to select a single column from the same record. You could replace that with a single SELECT:
SQL
SELECT 
    @CA_ID = CA_ID,
    @BA_ID = BA_ID,
    @SA_ID = SA_ID,
    @CIP_ID = CIP_ID,
    @CC_ID = CC_ID 
FROM 
    COMPLETEDORDERS 
WHERE 
    CompletedOrderID = @CompletedOrderID
;



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


GeneralRe: multiple joins, works in sql manager but not in asp.net Pin
jkirkerx2-Apr-15 12:09
professionaljkirkerx2-Apr-15 12:09 
Questionimage in database Pin
vinay dahiya1-Apr-15 11:40
vinay dahiya1-Apr-15 11:40 
GeneralRe: image in database Pin
PIEBALDconsult1-Apr-15 12:08
mvePIEBALDconsult1-Apr-15 12:08 
GeneralRe: image in database Pin
vinay dahiya1-Apr-15 12:15
vinay dahiya1-Apr-15 12:15 
GeneralRe: image in database Pin
PIEBALDconsult1-Apr-15 12:22
mvePIEBALDconsult1-Apr-15 12:22 
GeneralRe: image in database Pin
vinay dahiya1-Apr-15 12:59
vinay dahiya1-Apr-15 12:59 
GeneralRe: image in database Pin
Richard MacCutchan1-Apr-15 21:22
mveRichard MacCutchan1-Apr-15 21:22 
GeneralRe: image in database Pin
vinay dahiya2-Apr-15 1:59
vinay dahiya2-Apr-15 1:59 
GeneralRe: image in database Pin
Richard MacCutchan2-Apr-15 2:38
mveRichard MacCutchan2-Apr-15 2:38 
GeneralRe: image in database Pin
vinay dahiya2-Apr-15 2:44
vinay dahiya2-Apr-15 2:44 
GeneralRe: image in database Pin
Eddy Vluggen1-Apr-15 22:25
professionalEddy Vluggen1-Apr-15 22:25 
GeneralRe: image in database Pin
vinay dahiya2-Apr-15 2:02
vinay dahiya2-Apr-15 2:02 
GeneralRe: image in database Pin
Richard MacCutchan2-Apr-15 2:39
mveRichard MacCutchan2-Apr-15 2:39 
GeneralRe: image in database Pin
vinay dahiya2-Apr-15 2:46
vinay dahiya2-Apr-15 2:46 
GeneralRe: image in database Pin
Eddy Vluggen2-Apr-15 3:25
professionalEddy Vluggen2-Apr-15 3:25 
GeneralRe: image in database Pin
Richard MacCutchan2-Apr-15 3:38
mveRichard MacCutchan2-Apr-15 3:38 
GeneralRe: image in database Pin
Eddy Vluggen2-Apr-15 3:02
professionalEddy Vluggen2-Apr-15 3:02 

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.