Click here to Skip to main content
15,947,785 members
Home / Discussions / Database
   

Database

 
AnswerRe: convert mints into hours Pin
Richard MacCutchan13-Feb-14 4:29
mveRichard MacCutchan13-Feb-14 4:29 
QuestionIt Should Print 12 but the output is NULL , Please tell me How to SET VALUE For the VAriable declare outside the SQL Text cretaed for dynamic query Pin
Dnyaneshwar@Pune13-Feb-14 1:52
Dnyaneshwar@Pune13-Feb-14 1:52 
AnswerRe: It Should Print 12 but the output is NULL , Please tell me How to SET VALUE For the VAriable declare outside the SQL Text cretaed for dynamic query Pin
Dnyaneshwar@Pune13-Feb-14 2:15
Dnyaneshwar@Pune13-Feb-14 2:15 
AnswerRe: It Should Print 12 but the output is NULL , Please tell me How to SET VALUE For the VAriable declare outside the SQL Text cretaed for dynamic query Pin
Richard Deeming13-Feb-14 2:51
mveRichard Deeming13-Feb-14 2:51 
GeneralRe: It Should Print 12 but the output is NULL , Please tell me How to SET VALUE For the VAriable declare outside the SQL Text cretaed for dynamic query Pin
Dnyaneshwar@Pune14-Feb-14 1:05
Dnyaneshwar@Pune14-Feb-14 1:05 
QuestionSQL query for availability Error Pin
Sniper 312-Feb-14 19:10
professionalSniper 312-Feb-14 19:10 
AnswerRe: SQL query for availability Error Pin
Chris Quinn12-Feb-14 20:52
Chris Quinn12-Feb-14 20:52 
GeneralRe: SQL query for availability Error Pin
Sniper 312-Feb-14 21:05
professionalSniper 312-Feb-14 21:05 
Hi Chris,

I am really happy for the quick response.

But there is no table and columns involved into this.

We have the data as below:-
SQL
(Complete Time of the Period – (Addition of Failures Durations)) / (N° of Failures + 1)*

*for n failures, there n + 1 periods of functioning, and therefore:

For example for a month as January with 44 640 seconds for the complete period and errors as below:

•   From 1/1/14 09:17 to 1/1/14 17:20, (error 1 duration = 483 minutes)
•   From 14/1/14 17:20 to 15/1/14 07:40 (error 2 duration = 860 minutes)
•   From 21/1/14 07:40 to 21/1/14 11:12 (error 3 duration = 212 minutes)

The MTBF would be:

(44 640 - (483 + 860 + 212)) / 4 = 5 385 minutes 30s, MTBF is 89 hours 45mn 30s = 3 days 17 hours 45mn 30s.


This is what we require for... Frown | :(
GeneralRe: SQL query for availability Error Pin
Chris Quinn12-Feb-14 21:08
Chris Quinn12-Feb-14 21:08 
GeneralRe: SQL query for availability Error Pin
Mycroft Holmes12-Feb-14 22:02
professionalMycroft Holmes12-Feb-14 22:02 
Questioncalculate percentage of two column value and store into other column Pin
Member 1056208612-Feb-14 19:00
Member 1056208612-Feb-14 19:00 
AnswerRe: calculate percentage of two column value and store into other column Pin
Simon_Whale12-Feb-14 22:29
Simon_Whale12-Feb-14 22:29 
GeneralRe: calculate percentage of two column value and store into other column Pin
Member 1056208612-Feb-14 22:41
Member 1056208612-Feb-14 22:41 
GeneralRe: calculate percentage of two column value and store into other column Pin
Simon_Whale12-Feb-14 22:45
Simon_Whale12-Feb-14 22:45 
AnswerRe: calculate percentage of two column value and store into other column Pin
Nicholas Swandel21-Feb-14 4:05
Nicholas Swandel21-Feb-14 4:05 
QuestionBest Database Configures with c# win. form Pin
agent_kruger11-Feb-14 1:04
professionalagent_kruger11-Feb-14 1:04 
AnswerRe: Best Database Configures with c# win. form Pin
Kornfeld Eliyahu Peter11-Feb-14 1:48
professionalKornfeld Eliyahu Peter11-Feb-14 1:48 
GeneralRe: Best Database Configures with c# win. form Pin
agent_kruger11-Feb-14 4:18
professionalagent_kruger11-Feb-14 4:18 
AnswerRe: Best Database Configures with c# win. form Pin
Kornfeld Eliyahu Peter11-Feb-14 4:24
professionalKornfeld Eliyahu Peter11-Feb-14 4:24 
GeneralRe: Best Database Configures with c# win. form Pin
GuyThiebaut11-Feb-14 4:54
professionalGuyThiebaut11-Feb-14 4:54 
GeneralRe: Best Database Configures with c# win. form Pin
Kornfeld Eliyahu Peter11-Feb-14 6:52
professionalKornfeld Eliyahu Peter11-Feb-14 6:52 
GeneralRe: Best Database Configures with c# win. form Pin
Member 1039216111-Feb-14 7:11
Member 1039216111-Feb-14 7:11 
QuestionRe: Best Database Configures with c# win. form Pin
Richard Deeming11-Feb-14 8:29
mveRichard Deeming11-Feb-14 8:29 
AnswerRe: Best Database Configures with c# win. form Pin
Jörgen Andersson12-Feb-14 3:15
professionalJörgen Andersson12-Feb-14 3:15 
GeneralRe: Best Database Configures with c# win. form Pin
Kornfeld Eliyahu Peter11-Feb-14 9:32
professionalKornfeld Eliyahu Peter11-Feb-14 9:32 

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.