Sorry, errors in my post, should be

update a

set a.b = ah.b,

a.seq = m.maxseq,

a.c = ah.c,

a.d = ah.d

from tablea a

inner join (select id, max([seq]) as...

How about this

(Removed at posters request)

Difficult to answer due to awkward table names but is this what your're after

update a

set a.a = b.a, a.b = b.b, a.c = b.c

from (select max(seq) as [seq]...

As long as the account can login into sql and as you stated has execute permissions on the proc then it should work. The best way is to try it...

Use trusted whenever possible, most secure.

Never use sa (even if password hidden), if you have to use sql login create specific login with minimum access.

is a left outer join faster than NOT EXISTS then ?

Generally yes but not always. I depends on...

I think it is a bug (sorry feature ) in SQL7. It works OK in  SQL2K.

The only way I found to get it to...

Paul is correct, this sort of formatting is normally done in the user app.

However if you want to right align with leading spaces you can use

SELECT STR(12,10,0)

which will produce a...

If you want to do it for all tables in a database you could use

sp_msforeachtable

GRANT ALL TO PUBLIC

grants statement access to public, where statement is CREATE DATABASE,CREATE DEFAULT etc. So you have allowed a member of public to create databases !

To grant at...

The only time I have seen it is when attempting INSERT / UPDATE via OPENQUERY

Here's a sample that may help

create table results ([ID] int, result text)

create table comments ([ID] int, CID int, CDate datetime, comment text)

insert into results values (123,'')

insert into...

Difficult to give exact answer without procedure listing but this would work.

declare @EchVPoin as decimal(18,2)

declare @noofVisits as int

set @noofVisits = 2

set @EchVPoin = 1.0 / @noofVisits

Update RMCPL_DAILY_ACTIVITY...

1.

I do not know of any personally, but like you would be interested to know of any.

2.

All my sp's are generated from txt files. I may use QA...

Kenneth, I would disagree with 'shaky', not ideal maybe.

The problem with using a semaphore is that if an error occurs that stops the procedure then the semaphore is not changed and you...