You have a value for BID in your C table that doesn't have a corresponding value for BID in your B table. The best way to resolve this is...

My point is that it's not only possible, but extremely likely to read your comments as recommending using an rCTE for new development for...

SQL Kiwi (1/12/2012)

---

The thread starter was not Bob Cullen (the chap playing around with an...

SQL Kiwi (1/12/2012)

---

Jeff and Chris,

You've missed the point I was making, and have chosen to assume that I am either (a) not aware of the performance issues involved; or (b)...

That's true, but this statement from the original poster sounds like the GROUP BY is...

SQL Kiwi (1/11/2012)

---

So 'B' is...

I think it's actually even simpler.

SELECT StudentID, Programme, Min([Year]) AS [Year]

FROM #Students

GROUP BY StudentID, Programme

HAVING Min([Year]) = 2009

You may not even need the HAVING clause depending on what you are...

SQL Kiwi (1/11/2012)

---

You might have missed that I quoted the performance impact directly from the article "(150ms from Jeff's article graph)", which is one I have read many times (see...

SQL Kiwi (1/11/2012)

---

drew.allen (1/11/2012)

---

Jeff Moden...

Jeff Moden has an article...

GSquared (1/9/2012)

---

Audit logging doesn't need to use the "inserted" data. You already have that in the table you just updated. Logging it just increases the size of the...

halifaxdal (1/9/2012)

---

Each digit represents a record in another table, let me explain here so you can see if my design is good, your suggestion could be better though:

Table 1: has...

This is sometimes done using a trigger, but you may not have rights to create a trigger on the table being updated. Another option is to use the OUTPUT...

I didn't notice that you...

You're confusing what IDENTITY is...