Click here to Skip to main content
14,669,578 members
Home » Discussions » Database
   

Database

 
GeneralRe: HELP WITH SQL QUERY Pin
GuyThiebaut4-Apr-19 21:17
professionalGuyThiebaut4-Apr-19 21:17 
GeneralRe: HELP WITH SQL QUERY Pin
BrunoPigeon5-Apr-19 0:11
MemberBrunoPigeon5-Apr-19 0:11 
GeneralRe: HELP WITH SQL QUERY Pin
GuyThiebaut5-Apr-19 2:48
professionalGuyThiebaut5-Apr-19 2:48 
GeneralRe: HELP WITH SQL QUERY Pin
BrunoPigeon5-Apr-19 4:22
MemberBrunoPigeon5-Apr-19 4:22 
QuestionIn Access: group of records and assign conditional group ? Pin
Member 245846726-Mar-19 22:18
MemberMember 245846726-Mar-19 22:18 
AnswerRe: In Access: group of records and assign conditional group ? Pin
Victor Nijegorodov27-Mar-19 11:50
MemberVictor Nijegorodov27-Mar-19 11:50 
GeneralRe: In Access: group of records and assign conditional group ? Pin
Member 24584677-Apr-19 16:20
MemberMember 24584677-Apr-19 16:20 
GeneralRe: In Access: group of records and assign conditional group ? Pin
Member 24584677-Apr-19 16:24
MemberMember 24584677-Apr-19 16:24 
from the original data I created the result, if the contract in the month has LOAIHD = "FBAN" and between (#01/01/2019# and #31/01/2019#) then [BOOL] = 1 else [BOOL = 0, I will describe the condition of [BOOL] in C# code

[CODE]
for (int i = 0; i < [Original data].Count; i++)
{
bool BOOLEAN = 0;
string SOHD = "";
if([NGAYGIAO].[i]>=#1/1/2019# && [NGAYGIAO].[i] <=#1/31/2019#) //dd/MM/yyyy
{
for (int j = 0; j < [Original data].Count; j++)
{
if([LOAIHD].[j] == "FBAN")
{
BOOLEAN = 1;
SOHD = [Original data].[HD].[j];
}

}
}
if(SOHD == [Original data].[HD].[i] && SOHD != "")
{
[Result].[BOOL].[i] = BOOLEAN;
}
}
[/CODE]
AnswerRe: In Access: group of records and assign conditional group ? Pin
Chris Quinn28-Mar-19 1:55
MemberChris Quinn28-Mar-19 1:55 
QuestionSQL Remote Connections Pin
Kevin Marois18-Mar-19 8:00
professionalKevin Marois18-Mar-19 8:00 
AnswerRe: SQL Remote Connections Pin
Richard Deeming18-Mar-19 9:35
mveRichard Deeming18-Mar-19 9:35 
GeneralRe: SQL Remote Connections Pin
Kevin Marois18-Mar-19 10:02
professionalKevin Marois18-Mar-19 10:02 
GeneralRe: SQL Remote Connections Pin
Richard Deeming19-Mar-19 1:57
mveRichard Deeming19-Mar-19 1:57 
GeneralRe: SQL Remote Connections Pin
Kevin Marois18-Apr-19 8:16
professionalKevin Marois18-Apr-19 8:16 
AnswerRe: SQL Remote Connections Pin
jschell23-Mar-19 6:01
Memberjschell23-Mar-19 6:01 
QuestionHelp with simple database Pin
Member 1418292514-Mar-19 13:14
MemberMember 1418292514-Mar-19 13:14 
AnswerRe: Help with simple database Pin
Richard MacCutchan14-Mar-19 23:06
mveRichard MacCutchan14-Mar-19 23:06 
AnswerRe: Help with simple database Pin
Eddy Vluggen14-Mar-19 23:17
professionalEddy Vluggen14-Mar-19 23:17 
AnswerRe: Help with simple database Pin
Mycroft Holmes15-Mar-19 12:49
professionalMycroft Holmes15-Mar-19 12:49 
PraiseRe: Help with simple database Pin
Peter_in_278015-Mar-19 14:20
professionalPeter_in_278015-Mar-19 14:20 
GeneralRe: Help with simple database Pin
Mycroft Holmes15-Mar-19 14:57
professionalMycroft Holmes15-Mar-19 14:57 
QuestionOracle database USER and SCHEMA [SOLVED] Pin
Valentinor11-Mar-19 9:16
MemberValentinor11-Mar-19 9:16 
AnswerRe: Oracle database USER and SCHEMA Pin
CHill6012-Mar-19 22:45
mveCHill6012-Mar-19 22:45 
GeneralRe: Oracle database USER and SCHEMA Pin
Valentinor13-Mar-19 1:30
MemberValentinor13-Mar-19 1:30 
GeneralRe: Oracle database USER and SCHEMA Pin
CHill6013-Mar-19 2:23
mveCHill6013-Mar-19 2:23 

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.