Click here to Skip to main content
15,860,861 members
Home / Discussions / Database
   

Database

 
AnswerRe: Displaying multiple rows into single row as columns based on id - Sql Server Pin
Victor Nijegorodov6-Mar-19 21:52
Victor Nijegorodov6-Mar-19 21:52 
GeneralRe: Displaying multiple rows into single row as columns based on id - Sql Server Pin
Member 111541886-Mar-19 23:24
Member 111541886-Mar-19 23:24 
AnswerRe: Displaying multiple rows into single row as columns based on id - Sql Server Pin
Richard Deeming6-Mar-19 22:08
mveRichard Deeming6-Mar-19 22:08 
GeneralRe: Displaying multiple rows into single row as columns based on id - Sql Server Pin
Member 111541886-Mar-19 23:21
Member 111541886-Mar-19 23:21 
GeneralRe: Displaying multiple rows into single row as columns based on id - Sql Server Pin
Mycroft Holmes7-Mar-19 10:50
professionalMycroft Holmes7-Mar-19 10:50 
QuestionHelp me with caculate debit balace and incredit by SQL server 2012 Pin
Member 141737536-Mar-19 19:08
Member 141737536-Mar-19 19:08 
Rant[REPOST] Help me with caculate debit balace and incredit by SQL server 2012 Pin
Richard Deeming6-Mar-19 21:58
mveRichard Deeming6-Mar-19 21:58 
QuestionSQL Access: Calculate the total elimination of records not the same month and year ? Pin
Member 24584674-Mar-19 21:26
Member 24584674-Mar-19 21:26 
I want to calculate the total conditional in the month but remove the records that are not the same month and not the same year, the condition that eliminates the view on the sql access because the result is true or false in the excel file http://www.mediafire.com/file/kq2mr2v6px1uxan/exercise.rar
SQL
DOANHTHU2: Sum(IIf(Not IsNull([DONGIA]),[SOLUONG]*([DONGIA]/1000000),[SOLUONG]*([DONGIATT]/1000000)))

DOANHTHU2: Sum(IIf(Not IsNull([DONGIA]) AND (SELECT COUNT(*) AS DEM FROM HDMUABAN WHERE (((HDMUABAN.HD)='M1101') AND ((HDMUABAN.LOAIHD)='FBAN') AND ((Month([NGAYGIAO]))=1) AND ((Year([NGAYGIAO]))=2019)) GROUP BY HDMUABAN.HD, HDMUABAN.NGAYGIAO, HDMUABAN.LOAIHD) AS NUM <=0,[SOLUONG]*([DONGIA]/1000000),[SOLUONG]*([DONGIATT]/1000000)))
TONGDOANHTHU2: IIf(Not IsNull([DOANHTHU2]) And Not IsNull([BSLN]),[DOANHTHU2]+[BSLN],IIf(IsNull([DOANHTHU2]) And Not IsNull([BSLN]),[BSLN],[DOANHTHU2]))

My example only removed one record, I designed the problem of removing many records if the same conditions exist
QuestionQuery Question Pin
milo-xml1-Mar-19 2:14
professionalmilo-xml1-Mar-19 2:14 
AnswerRe: Query Question Pin
Afzaal Ahmad Zeeshan1-Mar-19 3:19
professionalAfzaal Ahmad Zeeshan1-Mar-19 3:19 
GeneralRe: Query Question Pin
milo-xml1-Mar-19 5:31
professionalmilo-xml1-Mar-19 5:31 
GeneralRe: Query Question Pin
Afzaal Ahmad Zeeshan1-Mar-19 7:46
professionalAfzaal Ahmad Zeeshan1-Mar-19 7:46 
GeneralRe: Query Question Pin
milo-xml1-Mar-19 8:05
professionalmilo-xml1-Mar-19 8:05 
AnswerRe: Query Question Pin
Eddy Vluggen1-Mar-19 7:46
professionalEddy Vluggen1-Mar-19 7:46 
GeneralRe: Query Question Pin
milo-xml1-Mar-19 8:03
professionalmilo-xml1-Mar-19 8:03 
GeneralRe: Query Question Pin
Eddy Vluggen1-Mar-19 8:51
professionalEddy Vluggen1-Mar-19 8:51 
QuestionMANAGEMENT DOCUMENT Pin
Member 1413102419-Feb-19 2:23
Member 1413102419-Feb-19 2:23 
AnswerRe: MANAGEMENT DOCUMENT Pin
Eddy Vluggen19-Feb-19 3:09
professionalEddy Vluggen19-Feb-19 3:09 
AnswerRe: MANAGEMENT DOCUMENT Pin
CHill6019-Feb-19 4:14
mveCHill6019-Feb-19 4:14 
AnswerRe: MANAGEMENT DOCUMENT Pin
Victor Nijegorodov19-Feb-19 9:27
Victor Nijegorodov19-Feb-19 9:27 
GeneralRe: MANAGEMENT DOCUMENT Pin
jschell23-Feb-19 11:03
jschell23-Feb-19 11:03 
GeneralRe: MANAGEMENT DOCUMENT Pin
Victor Nijegorodov23-Feb-19 11:07
Victor Nijegorodov23-Feb-19 11:07 
AnswerRe: MANAGEMENT DOCUMENT Pin
ZurdoDev1-Mar-19 5:52
professionalZurdoDev1-Mar-19 5:52 
QuestionHibernate error ORA-02289: sequence does not exist [SOLVED] Pin
Valentinor16-Feb-19 5:37
Valentinor16-Feb-19 5:37 
AnswerRe: Hibernate error ORA-02289: sequence does not exist Pin
Richard Deeming18-Feb-19 1:42
mveRichard Deeming18-Feb-19 1:42 

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.