Click here to Skip to main content
14,172,361 members
   

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 
GeneralMessage Closed Pin
22-Mar-19 21:10
memberMember 1419297522-Mar-19 21:10 
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
protectorRichard MacCutchan14-Mar-19 23:06 
AnswerRe: Help with simple database Pin
Eddy Vluggen14-Mar-19 23:17
mveEddy Vluggen14-Mar-19 23:17 
AnswerRe: Help with simple database Pin
Mycroft Holmes15-Mar-19 12:49
memberMycroft 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
memberMycroft 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
protectorCHill6012-Mar-19 22:45 
GeneralRe: Oracle database USER and SCHEMA Pin
Valentinor13-Mar-19 1:30
memberValentinor13-Mar-19 1:30 

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
Web04 | 2.8.190524.3 | Last Updated 24 May 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid