Rearrange the query a little.

When you are filtering on a record that is in one of the left/right join tables, it also has a null effect on the Outer join...

If you mix Left/Right joins with inner joins (only on referencing tables) it has a nullifying effect.

Not Tested

SELECT m.module_id, p.page_name, p.page_url

FROM user_permissions up

RIGHT OUTER JOIN module m on up.module_id...

Sure you can, what you do to a1.au_lname you have to do to a2.au_lname

select rank=count(*), a1.au_lname, a1.au_fname

from authors a1, authors a2

where a1.au_lname + a1.au_fname >= a2.au_lname + a2.au_fname

 ...

Please don't Cross Post

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=219894

Minor detail

You state "If all records in table child" Does this mean table wide, or if All detail records for a parent?

If table wide, then what status record should be...

Without answering your question directly

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q186133

Ranking from sql (Numbering results) has a cost, IMHO the cycles are better spent on the presentation layer.

But I understand there are circumstances where...

Well, you have left quite a bit of information out.

you have 5 tables, and each table has a matching table?

I'm assuming yes.

So for each of the 5 tables you need...

Developers are a Carniverous lot.

That app that builds apps. Kind of leaves developers out of the loop once it gets accomplished.

Cutoff your nose in spite of your face.

I've worked several...

You want users that have full control over what?

Don't understand on what you mean by who owns service account.

To figure out what users have access to what data files are...

How do U keep a dba in suspense.

Tell U tomorrow!!

its 10:04, where's my big announcement?

Depends on your previous experience level.

If you go to amazon, and look for t-sql, they will show you a bunch of books, but off to the right under list mania,...

Next version is sql 2005, and it will be out later this fall. There are no other released versions sql 2000 was the last realeased version.

Apparently there is some big...

How Bout

sp_who2

-- Retrieve the sql of this connection

DECLARE @handle binary(20)

SELECT @handle = sql_handle

    FROM master..sysprocesses

    WHERE spid = 54  -- Your Spid Here

SELECT [text]

    FROM ::fn_get_sql(@handle)

IMHO, Initially I would say no that would not be a great place to use a calculated field. But again I guess it depends. Do you store the previous years...

Is server in mixed mode or windows only mode?

Are you connectiong w/ sql login, or domain account?

that error only indicates that sql server does not know who you are. No...