Thanks for this article. There's a lot to consider here.

In the CROSS JOIN section, the query

[font="Courier New"]SELECT S.name, J.name

FROM dbo.Student S

CROSS

JOIN dbo.Subject J

ORDER BY S.name ASC, S.name ASC;

[/font]

should read

[font="Courier New"]SELECT S.name, J.name

FROM dbo.Student S

CROSS

JOIN dbo.Subject J

ORDER BY S.name ASC, J.name ASC;[/font]

should it not?