how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

0 Answers   United Healthcare,

---

What is shrink log file?

0 Answers  

---

What is the maximum size of a dimension? : sql server analysis services, ssas

0 Answers  

---

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

0 Answers  

---

CLR Integration ? what is Notification services ?

1 Answers   HCL, Satyam,

---

---

Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

5 Answers   TCS,

---

Get Current System Date Time

2 Answers  

---

Explain insert into select statement?

0 Answers  

---

Differences between Standby Vs No recovery?

2 Answers   Wipro,

---

Explain what are partitioned views and distributed partitioned views?

0 Answers  

---

What is normalization and its types?

0 Answers  

---

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 Answers  

---