Gianluca Sartori (8/11/2009)

---

Add filter conditions for the main table (TableA) in the WHERE clause, then add filters for TableB in the JOIN conditions.

SELECT *

FROM TableA

LEFT JOIN TableB

ON (TableA.ID1=TableB.ID1 AND TableA.ID2=TableB.ID2...

lnelson (8/11/2009)

---

SQL 2005 I have a table with the following fields:

Segment1 (nvarchar(50), null)

Segment2 (nvarchar(50),null)

national_identifier(nvarchar(50), null)

The actual data contained in these fields is typically numbers. The national identifier contains social...

mtassin (8/11/2009)

---

Lynn Pettis (8/10/2009)

---

mtassin (8/10/2009)

---

I'm sure she wasn't hinting at you. I am pretty sure I have an idea or two who she was thinking about as she wrote...

Paul White (8/10/2009)

---

GSquared (8/10/2009)

---

Have to sort of disagree with you on this one. Temp tables cause statement recompiles in 2005/8, and proc recompiles in 2000, but even those are...

Can you explain what you are looking for or why it is important to do this?

mtassin (8/10/2009)

---

GilaMonster (8/10/2009)

---

mtassin (8/10/2009)

And who determines who should be in the group? If it's forum ranking alone, there are several people (who shall remain unnamed) with over 1000 points and...

Or something like this. Uploaded as an attachment as I am having problems posting it directly.

Are you inserting a new row or updating the existing row (ie there is only one row in the table)?

Totally different subject! I suddenly can't wait to get home tonight (not that I don't look forward to going home :-P)!

We just received some letters from Kassondra. Looking...

WebTechie38 (8/10/2009)

---

Hello,

I have a big database that needs to be backed up. The combination of the .mdf and the .ldf should be around 55 GB or so. The...

timothyawiseman (8/10/2009)

---

Andy DBA (8/10/2009)

---

I agree with Tim that many readers will assume endorsement by SSC and might not read any of the comments or even be aware of their presence....

John Paul (8/10/2009)

---

Updated code : and According to my understanding

returns one row per Country Code with three porttypes import type columns

For each class the ports import...

True, but we work with what we are given, wether here on SSC or at work. 😉

jacroberts (8/10/2009)

---

Lynn Pettis (8/10/2009)

---

LP (8/10/2009)

---

Absolutely agreed. Very dangerous article espesially...

Not only that, it looks like we could completely drop the #ProductDetail table, as it adds nothing to the query from what I can see.