Let us throw in another monkey into the wrench. What happens if the job is started at 20 minutes after the hour, and for various reasons ends up running...

Using your test setup try the following:

select RunnerId, [1] as Contest1, [2] as Contest2

from

(select Id, RunnerId, ContestId from #tblResults) p

pivot (

count([Id])

for ContestId in ([1],[2])

) as pvt

order by RunnerId;

It isn't a bug in SQL Server 2008 (and yes, there are SQL Server 2008 forums available). I changed the datatype from time to datetime and ran your original...

Assumptions:

1. Single Reporting Job: Report Job

2. Multiple Schedules:

Schedule 1, every hour between 6:00 AM and 6:00 PM (i.e 6:00, 7:00, 8:00,...)

Schedule 2,...

GilaMonster (8/11/2009)

---

Chad Crawford (8/11/2009)

---

Gianluca Sartori (8/11/2009)

---

Some time ago there was a thread entitled "Should you use your real name as nickname?".

Maybe it's time to start the "Should you use your...

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