Click here to Skip to main content
14,696,276 members
Home » Discussions » Database
   

Database

 
GeneralRe: Query Question Pin
milo-xml1-Mar-19 9:05
professionalmilo-xml1-Mar-19 9:05 
AnswerRe: Query Question Pin
Eddy Vluggen1-Mar-19 8:46
professionalEddy Vluggen1-Mar-19 8:46 
GeneralRe: Query Question Pin
milo-xml1-Mar-19 9:03
professionalmilo-xml1-Mar-19 9:03 
GeneralRe: Query Question Pin
Eddy Vluggen1-Mar-19 9:51
professionalEddy Vluggen1-Mar-19 9:51 
QuestionMANAGEMENT DOCUMENT Pin
Member 1413102419-Feb-19 3:23
MemberMember 1413102419-Feb-19 3:23 
AnswerRe: MANAGEMENT DOCUMENT Pin
Eddy Vluggen19-Feb-19 4:09
professionalEddy Vluggen19-Feb-19 4:09 
AnswerRe: MANAGEMENT DOCUMENT Pin
CHill6019-Feb-19 5:14
mveCHill6019-Feb-19 5:14 
AnswerRe: MANAGEMENT DOCUMENT Pin
Victor Nijegorodov19-Feb-19 10:27
MemberVictor Nijegorodov19-Feb-19 10:27 
GeneralRe: MANAGEMENT DOCUMENT Pin
jschell23-Feb-19 12:03
Memberjschell23-Feb-19 12:03 
GeneralRe: MANAGEMENT DOCUMENT Pin
Victor Nijegorodov23-Feb-19 12:07
MemberVictor Nijegorodov23-Feb-19 12:07 
AnswerRe: MANAGEMENT DOCUMENT Pin
ZurdoDev1-Mar-19 6:52
mveZurdoDev1-Mar-19 6:52 
QuestionHibernate error ORA-02289: sequence does not exist [SOLVED] Pin
Valentinor16-Feb-19 6:37
MemberValentinor16-Feb-19 6:37 
AnswerRe: Hibernate error ORA-02289: sequence does not exist Pin
Richard Deeming18-Feb-19 2:42
mveRichard Deeming18-Feb-19 2:42 
GeneralRe: Hibernate error ORA-02289: sequence does not exist Pin
Valentinor18-Feb-19 3:37
MemberValentinor18-Feb-19 3:37 
AnswerRe: Hibernate error ORA-02289: sequence does not exist [SOLVED] Pin
Valentinor18-Feb-19 3:59
MemberValentinor18-Feb-19 3:59 
QuestionOracle SQL Developer filter "default tables" [SOLVED] Pin
Valentinor16-Feb-19 4:16
MemberValentinor16-Feb-19 4:16 
AnswerRe: Oracle SQL Developer filter "default tables" Pin
Jörgen Andersson16-Feb-19 8:25
professionalJörgen Andersson16-Feb-19 8:25 
GeneralRe: Oracle SQL Developer filter "default tables" Pin
Valentinor16-Feb-19 8:54
MemberValentinor16-Feb-19 8:54 
AnswerRe: Oracle SQL Developer filter "default tables" Pin
Valentinor16-Feb-19 9:04
MemberValentinor16-Feb-19 9:04 
QuestionCan't Get Required Output while executing Store Procedure. Any help would be appreciated ? Pin
K K Shah14-Feb-19 0:18
Member K K Shah14-Feb-19 0:18 
When i execute the procedure what i get the output is like -

ALTER PROC [dbo].[PROC_EMPLOYEE_PAY_SLIP]
@EmplopyeeCode varchar(100),
@MonthName varchar(50),
@Year Float
As
Begin
SELECT ISNULL(HR_EmployeeMaster.em_EmplopyeeCode,'') As EmplopyeeCode,
ISNULL(CASE WHEN fa_ComponentMaster.Cm_ADTag = 'A' THEN fa_ComponentMaster.Cm_Name ELSE '' END,'') As Additions,
ISNULL(CASE WHEN fa_ComponentMaster.Cm_ADTag = 'D' THEN fa_ComponentMaster.Cm_Name ELSE '' END,'') As Deductions,
ISNULL(CASE WHEN fa_ComponentMaster.Cm_ADTag = 'A' THEN Fa_MonthSalary.Ms_Amount ELSE 0 END,0) As AdditionsAmount,
ISNULL(CASE WHEN fa_ComponentMaster.Cm_ADTag = 'D' THEN Fa_MonthSalary.Ms_Amount ELSE 0 END,0) As DeductionsAmount
FROM HR_EmployeeMaster
LEFT JOIN Fa_MonthSalary ON Fa_MonthSalary.ms_EmpCode = @EmplopyeeCode
LEFT JOIN Fa_MonthDetails ON Fa_MonthDetails.mo_id = Fa_MonthSalary.Ms_MonCode
LEFT JOIN fa_ComponentMaster ON fa_ComponentMaster.cm_code = Fa_MonthSalary.Ms_CompCode
WHERE HR_EmployeeMaster.em_EmplopyeeCode = @EmplopyeeCode AND
(SELECT CONVERT(CHAR(3), Fa_MonthDetails.mo_name)) = @MonthName AND
Fa_MonthDetails.mon_year = @Year
End

Current Output -

EmployeeCode  Additions      Deductions   AdditionsAmount  DeductionsAmount
M1010         ALLOWANCE                     960.00               0
M1010         BASIC SALARY                  1390.00              0
M1010         OT1                           171.35               0
M1010                        OTHERS-DED     0.00                 1800.00


Required Output -

EmployeeCode  Additions      Deductions   AdditionsAmount  DeductionsAmount
M1010         ALLOWANCE      OTHERS-DED     960.00               1800.00
M1010         BASIC SALARY                  1390.00              0
M1010         OT1                           171.35               0


Any help would be appreciated Frown | :(
AnswerRe: Can't Get Required Output while executing Store Procedure. Any help would be appreciated ? Pin
Richard MacCutchan14-Feb-19 2:35
mveRichard MacCutchan14-Feb-19 2:35 
QuestionMongoDB Transactions Pin
Kevin Marois13-Feb-19 15:25
professionalKevin Marois13-Feb-19 15:25 
AnswerRe: MongoDB Transactions Pin
k505414-Feb-19 7:09
mvek505414-Feb-19 7:09 
QuestionC# MongoDB Question Pin
Kevin Marois10-Feb-19 8:58
professionalKevin Marois10-Feb-19 8:58 
AnswerRe: C# MongoDB Question Pin
k505412-Feb-19 7:07
mvek505412-Feb-19 7:07 

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.