Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

How to use "begin ... End" statement structures in ms sql server?

0 Answers  

---

How to use linked server?

0 Answers  

---

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

1 Answers  

---

Tell me what is the order in which the sql query is executed?

0 Answers  

---

Does any body please help me what question's have asked for SSRS in the interview?

0 Answers  

---

Write query to return all rows sql?

0 Answers  

---

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

---

What is difference between views and stored procedures?

0 Answers  

---

Do you know what is a linked server in sql server?

0 Answers  

---

How to execute multiple stored procedures at one time in sql server?

0 Answers  

---

How to retrieve field values using mssql_result()?

0 Answers  

---