Andy,

I am your father.

Steve Jones

steve@dkranch.net

you might have them. Consider that portland has both a Maine and an Oregon entry. The index structure could be more compact since there could be more cities under Oregon....

thanks for the update.

Steve Jones

steve@dkranch.net

2nd vote for that method.

Steve Jones

steve@dkranch.net

A few ways. If this is strict sql, I'd do

where datepart( year, mydate) = datepart( year, getdate())

and datepart( month, mydate) = datepart( month, getdate())

and datepart( day,...

select person, max( date)

from table

group by person

Steve Jones

steve@dkranch.net

Don't think it affects performance. Likely the parser handles this, so the query engine will not even see it.

I ALWAYS use aliases.

Steve Jones

steve@dkranch.net

can you post your code? I am not sure what you are describing?

Try this:

create table MyTable

(MyPK int

, MyID int

, MyChar char(4)

)

go

create trigger MyTable_Update on MyTable for Update

as

if Update(MyID)

...

No way to force this. Another argument for NT Authentication. Otherwise you'd have to write some process as suggested above.

Steve Jones

steve@dkranch.net

Pls don't cross post.

Steve Jones

steve@dkranch.net

Can you post what you tried alogn with some more sample data. Not entirely sure what you mean. Also include the table DDL.

Steve Jones

steve@dkranch.net

I understand that with the SQL login you can determine who the person is, join this to some table and allow them to "retrieve" the file. Makes sense. Personally, I'd...

Check out script library. There are a few there.

Steve Jones

steve@dkranch.net

The only thing I can think of is generate a single columns as

select firstname + char(13) + middle + char(13)...

Steve Jones

steve@dkranch.net

What's "a lot" of traffic. Have done this and not seen substantial overhead.

Steve Jones

steve@dkranch.net