Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 Answers  

---

how to trace the traffic hitting a sql server? : Sql server database administration

0 Answers  

---

What is xdr?

0 Answers  

---

what operator performs pattern matching?

2 Answers  

---

Difference between Cluster and Non-cluster index?

32 Answers   Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,

---

What is the optimization being performed in oracle and SQL Server?

0 Answers   Cap Gemini,

---

What is clustered vs nonclustered index?

0 Answers  

---

What is field with example?

0 Answers  

---

How do I make a resultset scrollable?

0 Answers  

---

 Explain what is sql override for a source taLle in a mapping?

0 Answers   Informatica,

---

Explain what role entity and relationship play in an ER diagram.

0 Answers  

---

A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

2 Answers   Sapient,

---