But the WHERE clause in that query will more or less always force an INNER JOIN. If you're filtering by the Child records, then that's what you're filtering by. The...

Gaby A. (12/24/2008)

---

dford (12/24/2008)

---

Lot of good responses here. I have to say, I don't like seeing lopsided articles about getting rid of cursors. They exist still partially because...

Thinking about it a bit more, you could combine older versions. Anything released 10 years ago or more will go into a "Previous Versions" folder with a the same four...

I agree. Consolidating the forums is a great idea. There really are too many to manage or browse through. I still think you should seperate them by version though. Even...

Jeff Moden (12/27/2008)

---

Heh... let's put it in terms of common sense... whether it's legal or not, would YOU want you SSN in clear text along with other personal and financial...

It looks very good. Nice job.

Ah... perfect. Thanks.

jpatevans4651 (12/24/2008)

---

Hi,

Is there no limit to stored procedure parameters because when I use ado.net I get the following when trying to call a stored procedure with 12 parameters:

Procedure or function...

Michael Valentine Jones (12/23/2008)

---

If there is someone doing a DBA interview that doesn’t have the technical understanding to be able to weed out a bogus DBA, then they probably shouldn’t...

J (12/23/2008)

---

This is interesting. Though I am a bit surprised a law would cover such a specific technical detail (primary key).

The OP has not confirmed if this is indeed the...

Don't mess with the magic... Pay no attention to that man behind the curtain...

It's just an illustration I've used for years to show beginners how joins work. If you really...

For the full list of sqlcmd settings and commands, please consult the Books Online.

I'd also suggest getting your DBA into the discussion here. They might have a good reason for using NOLOCK, or, more likely, they need a better understanding of what it...

Draw two intersecting circles. Circle 1 is your first table and Circle 2 is the second.

An inner join is the area within the intersection of the circles.

A left join is...

Glad I was a bit helfpul.

Yeah, I learn something new from Gail almost daily. On the rare occasions she doesn't teach me something new, she asks a question or makes...