You probabely tried to change the type of the function (some return tables, other table variables and the last type a scalar value). And it is forbiden to alter the...

Try dropping the function and recreating it with your code (swapping alter with create).

Good, point... the least we need is the list of the meetings (assuming, everyone has to attend to every meeting).

Great .

It's alright... you're more likely to get help in the access section anyways with this question.

If you look like you're pic then it's fine... if you look like me then I'll pass on the love .

We'll give a shot at the speed issue but don't expect this code to ever run lightning fast...

case S.Valor

when -1 then 'Users'

when -2 then 'Host'

else r.RoleName

end as Description

Ya, I'm pretty sure you don't need a function to make this trigger work.

Ok, can you run this code in the proc... that'll answer your question :

Update statement

print @@rowcount

then run from QA and see if you have 1 or 2 in there......

Please do not cross-post, we monitor all boards.

Finish the thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=131&messageid=233096

Maybe you could add the @@rowcount logic in the procedure after the update...

Also why do you want to trigger to do work on only one row at the time?

The link we provided will answer the next 20 question you'd have posted. Take it like :

Give him a fish, feed im for a day, take him to...

Please post the table definition and some sample data that makes this fail so we can write the trigger for you.

Assuming DateReceived column exists, then you could order by that as well.