Untested, but you could give this a try:

with MaxFundDate (

Fund_Number,

Fund_Valuation_Date

) as (

select

Fund_Number,

max(Fund_Valuation_Date

from

...

You could use isnull(tb.ID,0), but that still doesn't match with anything in your sample data.

Based on your sample data, the only way I see to do this is with the following code:

select

*

from

dbo.TableA ta

...

Shark Energy (8/11/2009)

---

I agree totally with all that, but why so that my servers can not interpret SELECT isdate('2009-06-30') as a valid date?

And surely these should both work if...

Okay, now I'm slightly confused. One, what are your requirements? We also could use the DDL for your tables, sample data for your tables, and the expected results...

Glad it worked, and thanks for the feedback.

Interesting. Too bad publications that do tech edit and peer review articles don't post warnings on their articles as well. I have read misinformation on other sites and...

If I were an ubber-geek, I'd figure out how to...

novice_coder (8/11/2009)

---

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...

I second George on still...

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?