Click here to Skip to main content
14,095,566 members
   

Database

 
AnswerRe: Having difficulty to replicate entries in SQL query result Pin
Richard MacCutchan28-Jan-19 2:56
protectorRichard MacCutchan28-Jan-19 2:56 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
paul4everyone28-Jan-19 4:20
memberpaul4everyone28-Jan-19 4:20 
SuggestionRe: Having difficulty to replicate entries in SQL query result Pin
ZurdoDev28-Jan-19 4:48
professionalZurdoDev28-Jan-19 4:48 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
paul4everyone28-Jan-19 6:54
memberpaul4everyone28-Jan-19 6:54 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
Richard MacCutchan28-Jan-19 6:01
protectorRichard MacCutchan28-Jan-19 6:01 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
paul4everyone28-Jan-19 6:51
memberpaul4everyone28-Jan-19 6:51 
AnswerRe: Having difficulty to replicate entries in SQL query result Pin
Mycroft Holmes28-Jan-19 11:02
memberMycroft Holmes28-Jan-19 11:02 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
paul4everyone28-Jan-19 15:02
memberpaul4everyone28-Jan-19 15:02 
CID in Table A is always single entry as a customer can't have two running loans as same time and in Table B CID is still single entry as is the account balance of all customers. But Table A.CID is always a subset of Table B.CID.
"guarantor" entries under CREDENTIAL column in Table C is just a string input ( like select 'guarantor' as CREDENTIAL) or (isnull(CREDENTIAL, 'guarantor')) to make me identify that entry as details of a particular guarantor while UNIQUE_ID entries in Table C helps groups individual loan together as both the loan collector and guarantors will have same entries.
CID in Table C can have multiple same values but all entries must be drawn from the primary column Table B.CID
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
Mycroft Holmes29-Jan-19 10:58
memberMycroft Holmes29-Jan-19 10:58 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
paul4everyone31-Jan-19 10:50
memberpaul4everyone31-Jan-19 10:50 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
Mycroft Holmes31-Jan-19 11:15
memberMycroft Holmes31-Jan-19 11:15 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
paul4everyone2-Feb-19 19:03
memberpaul4everyone2-Feb-19 19:03 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
Mycroft Holmes2-Feb-19 19:29
memberMycroft Holmes2-Feb-19 19:29 
Questionis it safe to use this with sql server and entity framework ? Pin
desanti9-Jan-19 14:38
memberdesanti9-Jan-19 14:38 
AnswerRe: is it safe to use this with sql server and entity framework ? Pin
Mycroft Holmes9-Jan-19 19:51
memberMycroft Holmes9-Jan-19 19:51 
AnswerRe: is it safe to use this with sql server and entity framework ? Pin
Eddy Vluggen10-Jan-19 2:17
mveEddy Vluggen10-Jan-19 2:17 
QuestionGetting error in SQL 2012 working fine in 2016 Pin
GaneshVidiyala25-Dec-18 21:41
professionalGaneshVidiyala25-Dec-18 21:41 
AnswerRe: Getting error in SQL 2012 working fine in 2016 Pin
jschell27-Dec-18 13:34
memberjschell27-Dec-18 13:34 
Questionssrs An attempt has been made to use a data extension 'ORACLE' error Pin
anjel8425-Dec-18 20:34
memberanjel8425-Dec-18 20:34 
AnswerRe: ssrs An attempt has been made to use a data extension 'ORACLE' error Pin
rnbergren24-Jan-19 8:24
memberrnbergren24-Jan-19 8:24 
QuestionCan't Insert data into Access Table from Python - Solved Pin
Peter R. Fletcher5-Dec-18 15:16
memberPeter R. Fletcher5-Dec-18 15:16 
AnswerRe: Can't Insert data into Access Table from Python Pin
Richard MacCutchan5-Dec-18 22:19
protectorRichard MacCutchan5-Dec-18 22:19 
GeneralRe: Can't Insert data into Access Table from Python Pin
Victor Nijegorodov6-Dec-18 1:09
memberVictor Nijegorodov6-Dec-18 1:09 
GeneralRe: Can't Insert data into Access Table from Python Pin
Richard MacCutchan6-Dec-18 1:21
protectorRichard MacCutchan6-Dec-18 1:21 
GeneralRe: Can't Insert data into Access Table from Python Pin
Peter R. Fletcher6-Dec-18 2:11
memberPeter R. Fletcher6-Dec-18 2:11 

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 | Cookies | Terms of Service
Web06 | 2.8.190518.1 | Last Updated 19 May 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid