Brendan - it sounds like you already know what to do:

select userID, (sum(timeKept) + sum(workQuality) + sum(Attitude)) as sumTotal

group by userID

noel - is your typing speed faster than Remi's...

noel - if at all your wife is French, then wine may go down much better (no pun intended!

That must be the same God who said "nothing succeeds like excess..."

Have long been a Bacchus worshipper....did you go down the same memory lane that is littered with chewed up crayons ?!?!

Also make sure you use single quotes and not double....

GRASS?!?! How strong is that ?! No wonder people are able to break the tie and separate on whim!

Now if they were handcuffed together (& the key was thrown away)...

Binu - I can't test this right now but it should be something like:

select Column, count(Column) as Number

from table group by Column

having count(Column) > 1

sswords -

You "tie the knot".... & then you're bound, united, whatever....

note - I did not say "tied down" etc.. before some gender divisive person in the name of Mike...

The meaning of "passed into procedure that builds table" is not clear but as for output of fields with entered values I think you may be looking for something like:

"select...

Maybe you should then use a windows api call:

Private Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" _

    (ByVal lpBuffer As String, nSize As Long) As Long

and insert the user name...

Chiranjib - I know that you can pass the results of the main SP as parameters to the second one as you're looping through.....is this what you mean ?!

ps: We've...

oh good - thx for getting back on this one 'cos I still haven't been able to test it!

Erik - could you please post the DDLs of your Company & Product table ?!

Reg. "is it possible to have another link" - sounds like you're talking about a composite...

Try using "select suser_sname()" or "select user_name()"

Glad it got sorted out!