Good suggestion re

Top new questions this week.

Greatest hits from previous weeks.

Can you answer these? (unanswered).

I use this site as my 5 minute tech education/awareness for the day. The TOC at the top gives me a quick check if there are topics of interest....

First, the assumption is that the person has some background that prompted management to make them "responsible". Classes and seminars are not the only way to learn. Being...

I would be interested to know if the discussions relative to specifying a default owner id are valid in a SS2005 environment. In SS2005 Logins are mapped to default...

If you are using SS2005, I have found Common Table Expressions useful for this type of problem. For example, make the second query a CTE.

Then you can join...