David Portas (11/4/2010)

---

Michael Wang (11/4/2010)

---

David Portas (11/4/2010)

---

Michael Wang (11/4/2010)

---

Two problems keep surfacing from this thread: confusion between a primary key and unique key constraints, and more fundamentally why the two...

David Portas (11/4/2010)

---

Michael Wang (11/4/2010)

---

Two problems keep surfacing from this thread: confusion between a primary key and unique key constraints, and more fundamentally why the two are required in the...

ebaya (11/4/2010)

---

Yes it does. You're still thinking at the database level. But a database is...

that's right: make sure you have a unique business key to constrain a record. But this is different from making it the PK. Another confusion between PK and...

I'm glad you caught me saying the word that I never use to myself. Apparently this is a bad word for you. But for countless DBAs who are unfortunately tasked...

this article serves a perfect example of data bases designed by those DBAs who understand little of the real business worlds and tend to take a static view of the...

Thank you, Declan, for the tip.

Any idea or pointers for my second question?

Michael

ps. I changed the original data a little bit: I set the termination dates to 1/1/2079 for those where term_date is null.  this is to avoid dealing with null fields,...

Using Vladan's table source, the data can be rearranged declaratively as follows:

-- first create a time line that is ponctuated by starting date and ending date

create table #t (rowno int...

I run similar query all the time.  If this is your primary query against UMF_SUM_MATCHLOG, you should create unique CLUSTERED index on (load_id, RECORD_TYPE, ...).  If no such index can...

I see nothing wrong with procedural code if implemeneted properly.  The original code has the problem of being too complex and is also limited in scope.  I ran it up...

Ryan, it was a nice try but would not solve my problem.

My example was a bit misleading: the numbers in Col2 do not...

To add to this subject, I twisted your question a little and here's another query:

select b.YearId, b.CourseId, a.StudentId, NumYears = count(*)

from TCourseTaken a inner join

(select Year = min(Year), CourseId, StudentId

...