Click here to Skip to main content
15,867,939 members
Home / Discussions / Database
   

Database

 
AnswerRe: Why does MySQL not convert dates before 2010-01-01? Pin
ZurdoDev21-Sep-20 7:03
professionalZurdoDev21-Sep-20 7:03 
QuestionHow to use a FileInfo control to add a filename to an Access database Pin
rodgerm25-Aug-20 14:51
rodgerm25-Aug-20 14:51 
AnswerRe: How to use a FileInfo control to add a filename to an Access database Pin
Richard MacCutchan25-Aug-20 21:16
mveRichard MacCutchan25-Aug-20 21:16 
QuestionDATABASE KEY Pin
Member 1492238425-Aug-20 0:42
Member 1492238425-Aug-20 0:42 
AnswerRe: DATABASE KEY Pin
OriginalGriff25-Aug-20 0:45
mveOriginalGriff25-Aug-20 0:45 
AnswerRe: DATABASE KEY Pin
ZurdoDev31-Aug-20 9:45
professionalZurdoDev31-Aug-20 9:45 
AnswerRe: DATABASE KEY Pin
Eddy Vluggen24-Sep-20 8:12
professionalEddy Vluggen24-Sep-20 8:12 
QuestionAny recommendations ora 01722 ??? Pin
Mahmoud Mohammad23-Aug-20 23:26
Mahmoud Mohammad23-Aug-20 23:26 
select  I."ItemOCode" as "Id", I."ItemNameA" as "Item", 
S."ACCNAME" as "SalesMan", sum(Decode(T."TransKind", 504, T."QtyIO")|| Decode(T."TransKind", 506, T."QtyIO")) * -1 as  "Sales", 
sum(Decode(T."TransKind", 504, T."BonusIO")|| Decode(T."TransKind", 506, T."BonusIO")) * -1 as   "Sales Bonus", 
sum(Decode(T."TransKind", 504, T."NetTL")||Decode(T."TransKind", 506, T."NetTL" ) * -1) as "Total Sales",
round((sum(Decode(T."TransKind", 504, T."BonusIO")||Decode(T."TransKind", 506, T."BonusIO")) * -1) / (sum(Decode(T."TransKind", 504, T."QtyIO")||Decode(T."TransKind", 506, T."QtyIO")) * -1) * 100,0) as "Bonus Rate",
 H."VHFNo" as "Invoice", H."AccCode", H."AccName" from "TransActn_S" T, "Item_Card" I, "Header_S" H , "SALESMEN" S 
where I."ItemOCode" = T."ItemOCode" and
 H."TransNo" = T."TransNo" and
 H."VHFNo" = T."VHFNo" and
 H."TransKind" = T."TransKind" AND
 (H."TransKind" = 504 OR H."TransKind" = 506) AND
 H."SalesManNo" in (00016,00034,00036,00119,00108,01000,00007) AND
 S."SALESNO" = TO_CHAR(H."SalesManNo") AND H."VHFDate" between '01/08/2020' and
 '24/08/2020' AND H."Stock_Code" = 1 group by I."ItemOCode", I."ItemNameA",S."ACCNAME",H."VHFNo" ,H."AccCode" ,H."AccName" 
order by I."ItemOCode"

AnswerRe: Any recommendations ora 01722 ??? Pin
Richard Deeming24-Aug-20 0:42
mveRichard Deeming24-Aug-20 0:42 
Questionsql server express 2014 named instance not connecting from outside network Pin
Member 1258438314-Aug-20 1:28
Member 1258438314-Aug-20 1:28 
AnswerRe: sql server express 2014 named instance not connecting from outside network Pin
Sandeep Mewara18-Aug-20 23:17
mveSandeep Mewara18-Aug-20 23:17 
QuestionAny good tool (free) for DB Schema? Pin
Sandeep Mewara14-Aug-20 0:01
mveSandeep Mewara14-Aug-20 0:01 
AnswerRe: Any good tool (free) for DB Schema? Pin
Richard MacCutchan14-Aug-20 1:44
mveRichard MacCutchan14-Aug-20 1:44 
GeneralRe: Any good tool (free) for DB Schema? Pin
Sandeep Mewara14-Aug-20 1:45
mveSandeep Mewara14-Aug-20 1:45 
GeneralRe: Any good tool (free) for DB Schema? Pin
Jörgen Andersson14-Aug-20 3:24
professionalJörgen Andersson14-Aug-20 3:24 
GeneralRe: Any good tool (free) for DB Schema? Pin
Sandeep Mewara14-Aug-20 3:39
mveSandeep Mewara14-Aug-20 3:39 
QuestionMS SQL Database Breach Pin
Otekpo Emmanuel13-Aug-20 4:03
Otekpo Emmanuel13-Aug-20 4:03 
AnswerRe: MS SQL Database Bridge Pin
Richard MacCutchan13-Aug-20 4:14
mveRichard MacCutchan13-Aug-20 4:14 
GeneralRe: MS SQL Database Bridge Pin
Otekpo Emmanuel13-Aug-20 5:02
Otekpo Emmanuel13-Aug-20 5:02 
AnswerRe: MS SQL Database Bridge Pin
Richard Deeming13-Aug-20 4:18
mveRichard Deeming13-Aug-20 4:18 
GeneralRe: MS SQL Database Bridge Pin
Otekpo Emmanuel13-Aug-20 5:01
Otekpo Emmanuel13-Aug-20 5:01 
GeneralRe: MS SQL Database Bridge Pin
Otekpo Emmanuel14-Aug-20 5:19
Otekpo Emmanuel14-Aug-20 5:19 
GeneralRe: MS SQL Database Bridge Pin
Richard Deeming14-Aug-20 5:38
mveRichard Deeming14-Aug-20 5:38 
GeneralRe: MS SQL Database Bridge Pin
Otekpo Emmanuel14-Aug-20 5:56
Otekpo Emmanuel14-Aug-20 5:56 
QuestionAws lamda Pin
Member 1490095628-Jul-20 2:16
Member 1490095628-Jul-20 2:16 

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.