Have a look at left outer joins...

(question aside: it's homework, isn't it?)

The Dixie Flatline (12/30/2010)

---

CTE is short for "Common table expression", which is an alternative to using a subquery. The CTE is not a temporary table; it produces...

r_slot (12/30/2010)

---

Looks good, but remember I am a newbie. So things are going to fast for me. First the beginning: ; with cte as - what is the meaning of...

... that will be provided free of...

Based on your sample data and Bob's code snippet I'd use the following aproach:

;

WITH cte AS

(

SELECT

Koersnaam,

COUNT(Koersid) AS Totaal,

MAX(CASE WHEN Jaar = 1948 THEN Score ELSE NULL END)...

The forum might be a good choice. But you might want to start a new thread.

I'm sorry I hijacked the thread with my NHibernate rant...

Seems like it got slightly off topic because of me.

Would you folks mind ranting about SSIS instead of something else in...

Please provide ready tu use sample data so we have something to test our solutions against.

For details on how to do please see the first link in my signature.

I tried...

Smalldatetime and Datetime get along very well...

Even if your data are in a character format (*yikes*), the implicit conversion should take care of it.

I don't think this will explain the...

Gianluca, thanx for sharing an EXCELLENT article!!!

dva2007 (12/30/2010)

---

You need to check the dateformat in the date time field you are using. If it is ymd then set on top before running t-sql statement to

set dateformat ymd...

Without seeing the actual code, it's unlikely to find an easy answer.

The error message usually will give you the line number where the error occured or you can simply double...

@parthi:

Your solution is based on copying the data to a staging table followed by an update, whereas a rather simple self-join will do the trick...

something like this?

DECLARE @tbl TABLE

(

col1 INT, Col2 CHAR(1)

)

INSERT INTO @tbl

SELECT 1 ,'A' UNION ALL

SELECT 2 ,'B' UNION ALL

SELECT 3 ,'C' UNION ALL

SELECT 4 ,'D' UNION ALL

SELECT...

LutzM (12/30/2010)

---

Nope, not in the version I checked (will be...