KWymore (3/21/2012)

---

I had only looked at the ANY and SOME syntax once before and did not see a need for them. They seem to perform exactly like the IN statement...

halifaxdal (3/20/2012)

---

I am sorry this post should not be closed yet, after some data verification, it turns out the query might need some amendment:

In MANY records showing "Table 1 is...

I think there's a lot to this subject. It's not a simple situation.

For example, we don't graduate people from school with the skills of problem solving, interpersonal dynamics, technical...

If you mean a column in a table, you can add a default value to one, like this:

alter table dbo.MyTable

add default(0) for MyColumn ;

You'll need to use real table and...

Is the "most recent date" the most recent ConnectedDate? If so, this will already do that. The Max() function in the sub-query does that.

Lynn Pettis (3/16/2012)

---

GSquared (3/16/2012)

---

Lynn Pettis (3/16/2012)

---

I think I'll go join the Guard Hippo at my Tent in the Desert. I really must be getting grumpy in my old age...

SSAS is definitely worth looking in to for this.

As far as references on where to go and how, I'd check the Microsoft Press books on the subject, and then dig...

Lynn Pettis (3/16/2012)

---

I think I'll go join the Guard Hippo at my Tent in the Desert. I really must be getting grumpy in my old age (no offense to...

Do a "Full Outer Join" between the two, on Name and Code, with whatever rules you need for other columns.

Something like:

SELECT *,

...

Could just be that the guy asking...

I don't think Year is SARGable. Better bet is "DateModified < '1/1/2012'".

SARGability may not matter much in this case, since it's liable to pull a range of data anyway,...

I can't test this, since I don't have table definitions, et al, but it should do what you need:

IF (@Type = 'GP')

BEGIN

...

You're...

Koen Verbeeck (3/15/2012)

---

*gasp*

It can be no coincidence that this topic is full of elite DBA's!

(for some strange reason I first...

Jeff Moden (3/15/2012)

---

GSquared (3/15/2012)

---

Jeff Moden (3/14/2012)

---

anthony.green (3/14/2012)

---

Jeff Moden (3/13/2012)

---

anthony.green (3/12/2012)

---

you might want to take a look at full text indexing and the contains function then, otherwise you will be wrapping...