How to call a function from a stored procedure in SQL Server ?

0 Answers   HCL,

---

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  

---

Explain the benefits of user-defined functions?

0 Answers  

---

what are candidate key, alternate key and composite key? : Sql server database administration

0 Answers  

---

Is it possible to create tables in stored procedures using a variable for the table name?

2 Answers  

---

How to write a query with a left outer join in ms sql server?

0 Answers  

---

What are four major operators that can be used to combine conditions on a where clause?

0 Answers  

---

Explain Different types of Projects?

1 Answers  

---

Can I delete event logs?

0 Answers  

---

please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on

1 Answers  

---

What is a result set object returned by odbc_exec()?

0 Answers  

---

How to invoke a trigger on demand?

0 Answers  

---