Click here to Skip to main content
15,905,028 members
Home / Discussions / Database
   

Database

 
GeneralRe: Which version of SqlServer is better for my work Pin
Wendelius4-Feb-09 7:54
mentorWendelius4-Feb-09 7:54 
GeneralRe: Which version of SqlServer is better for my work Pin
VisualLive4-Feb-09 15:20
VisualLive4-Feb-09 15:20 
Questionaudit trail Pin
NidhiKanu2-Feb-09 18:58
professionalNidhiKanu2-Feb-09 18:58 
AnswerRe: audit trail Pin
N a v a n e e t h2-Feb-09 19:06
N a v a n e e t h2-Feb-09 19:06 
GeneralRe: audit trail Pin
NidhiKanu2-Feb-09 19:18
professionalNidhiKanu2-Feb-09 19:18 
QuestionSQL For selecting consecutive rows with time difference Pin
pratap19802-Feb-09 13:11
pratap19802-Feb-09 13:11 
AnswerRe: SQL For selecting consecutive rows with time difference Pin
Wendelius2-Feb-09 18:19
mentorWendelius2-Feb-09 18:19 
Questioncount total records and (number of records based on a condition) for same column in single sql query Pin
chandrubngit2-Feb-09 5:28
chandrubngit2-Feb-09 5:28 
i'm using vb.net 2008 with msaccess 2003 database.i'm writing an windows application for calculating the employees attendance details like Number

of days worked, No of days Absent.I've a column named "Status" in access table.

query="SELECT Employee_ID, Employee_Name, count (*) as [Total Days] From EmpTable Where (Employee_Name='" & ComboBox1.Text & "' and

Attendance_Date between #" & Me.DateTimePicker1.Value.Date & "# and #" & Me.DateTimePicker2.Value.Date & "#) group by Employee_ID,

Employee_Name"

this query me ...Total Days (total working days including absent & present days of employee) as shown in the picture (Total Days column).I also wanted to show a new column which gives No of Days Present...so my query should look like this....

select count(*) as [Days Present] from EmpTable Where (Employee_Name='" & ComboBox1.Text & "' and

Attendance_Date between #" & Me.DateTimePicker1.Value.Date & "# and #" & Me.DateTimePicker2.Value.Date & "# and status='P')

i'm adding status column condition in where clause..."P" stands for present...as stored in status column of access database.

my requirement is to show the result using both the above mentioned queries...i mean how to combine these two queries into a single query which gives the output as i mentioned.
AnswerRe: count total records and (number of records based on a condition) for same column in single sql query Pin
Colin Angus Mackay2-Feb-09 5:52
Colin Angus Mackay2-Feb-09 5:52 
GeneralRe: count total records and (number of records based on a condition) for same column in single sql query Pin
Wendelius2-Feb-09 6:13
mentorWendelius2-Feb-09 6:13 
AnswerRe: count total records and (number of records based on a condition) for same column in single sql query Pin
Wendelius2-Feb-09 6:13
mentorWendelius2-Feb-09 6:13 
GeneralRe: count total records and (number of records based on a condition) for same column in single sql query Pin
chandrubngit18-Feb-09 23:51
chandrubngit18-Feb-09 23:51 
GeneralRe: count total records and (number of records based on a condition) for same column in single sql query Pin
Wendelius19-Feb-09 5:54
mentorWendelius19-Feb-09 5:54 
QuestionRun single instance of an application Pin
ashok_rgm2-Feb-09 2:22
ashok_rgm2-Feb-09 2:22 
AnswerRe: Run single instance of an application Pin
Wendelius2-Feb-09 3:01
mentorWendelius2-Feb-09 3:01 
AnswerRe: Run single instance of an application Pin
Colin Angus Mackay2-Feb-09 3:02
Colin Angus Mackay2-Feb-09 3:02 
GeneralRe: Run single instance of an application Pin
ashok_rgm2-Feb-09 22:20
ashok_rgm2-Feb-09 22:20 
Questionmcd and history table Pin
foryou2-Feb-09 1:49
foryou2-Feb-09 1:49 
AnswerRe: mcd and history table Pin
Paddy Boyd2-Feb-09 2:03
Paddy Boyd2-Feb-09 2:03 
AnswerRe: mcd and history table Pin
Colin Angus Mackay2-Feb-09 2:18
Colin Angus Mackay2-Feb-09 2:18 
GeneralRe: mcd and history table Pin
foryou2-Feb-09 2:58
foryou2-Feb-09 2:58 
QuestionRe: mcd and history table Pin
foryou2-Feb-09 23:24
foryou2-Feb-09 23:24 
QuestionMS-ACCESS combofilling [modified] Pin
ketan bader1-Feb-09 20:02
ketan bader1-Feb-09 20:02 
AnswerRe: MS-ACCESS combofilling Pin
Vimalsoft(Pty) Ltd1-Feb-09 23:06
professionalVimalsoft(Pty) Ltd1-Feb-09 23:06 
AnswerRe: MS-ACCESS combofilling Pin
Blue_Boy1-Feb-09 23:09
Blue_Boy1-Feb-09 23:09 

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.