Click here to Skip to main content
15,936,897 members
Home / Discussions / Database
   

Database

 
GeneralRe: Where to do the processing Pin
Mycroft Holmes16-Feb-14 11:44
professionalMycroft Holmes16-Feb-14 11:44 
AnswerRe: Where to do the processing Pin
GuyThiebaut17-Feb-14 0:17
professionalGuyThiebaut17-Feb-14 0:17 
GeneralRe: Where to do the processing Pin
Mycroft Holmes17-Feb-14 0:34
professionalMycroft Holmes17-Feb-14 0:34 
GeneralRe: Where to do the processing Pin
GuyThiebaut17-Feb-14 0:39
professionalGuyThiebaut17-Feb-14 0:39 
AnswerRe: Where to do the processing Pin
Jörgen Andersson17-Feb-14 0:59
professionalJörgen Andersson17-Feb-14 0:59 
AnswerRe: Where to do the processing Pin
jschell17-Feb-14 12:16
jschell17-Feb-14 12:16 
AnswerRe: Where to do the processing Pin
Nicholas Swandel21-Feb-14 8:46
Nicholas Swandel21-Feb-14 8:46 
Questionconvert mints into hours Pin
Member 1056208613-Feb-14 2:59
Member 1056208613-Feb-14 2:59 
Quote:
SQL
select distinct(Emp_Status),
       count ( Att_Mints/60) as OTHOUR,
       COUNT (Att_Totalmints /60 ) as ProductionHours
       from Attendence
       inner join EmployeeMaster on fk_Att_EmpCode=fk_Att_EmpCode
where year(Att_Date)='2014' and Month (Att_Date)='1'
 group by Emp_Status


in above query Count of
Att_Mints
is =150
and count of
Att_Totalmints
is 120

i want output of OTHOURS=1:30min
and
ProductionHours
=2 hour


please help me

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 
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 

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.