Check out the requirements... Seems like you pretty much have to have SP1 installed :

Enterprise requirements

Just a lucky guess, that's how it works in 2k. It looks like this is an old standard .

I think that the question is more about the difference between selecting form a view vs selecting from the base table.

Does your statement actually work???

Yes the 0 comes from the red part.

Also you better get used to that syntax because it's the only way to do this in sql server.

What was wrong with the statement I posted?

No I'm not employed here.

The crazy part is that I joined in may 2k4 .

I'll refrain from answering that question... This syntax is like the one in access and it seems like the right translation. Can you try it to see if it...

Now that would be an idea .

CASE WHEN PayDay IS NOT NULL THEN AltValue ELSE 0 END AS totPaid

Sounds about right??

check this out :

exec sp_msforeachdb 'Select ''?'' as dbName, * from ?.dbo.SysObjets'

Try replacing the quotes with wrapping # (#2005/01/01#).

Yup >> RGR'us - A fitting nickname

Obviously ! Here are the results on a slow server (in production) :

Select TOP 100 PERCENT

dtA.Frst

+ dtB.Sec

+ dtC.ThD

+ dtD.Fourth

+...

Good point... assuming you can afford a lock on the system tables for a few minutes.

Anyway you can upgrade to access 2K at least??????????????

Never worked with anything under 1997 and even that was a pain.