How to select some specific rows from a table in ms sql server?

0 Answers  

---

I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers  

---

System requirements for sql server 2005 express edition?

0 Answers  

---

What is a db view?

0 Answers  

---

What is compression - row-level and page-level compression?

0 Answers  

---

How can u convert the Date to String?

6 Answers   Microsoft, TCS,

---

can we have a nested transaction? : Sql server database administration

0 Answers  

---

What are the types of database recovery models?

0 Answers   HCL,

---

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,

---

How can i change the column name.

13 Answers   HCL, Yardi Software,

---

How to retrieve error messages using mssql_get_last_message()?

0 Answers  

---

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

7 Answers   Value Labs,

---