Hi,

I have tried this one already.

It showed the first value I put in and then it shows the table where I know the value exists, but I need to know...

Don't worry I have the answer.

Use Round:

SELECT ROUND('10.456',2,1)

This will return 10.45

Well thank you guys for all your help. I have learned a lot and I couldn't have done it with out you guys.

So it will look something like this then?

DELETE pat FROM PAT_ACCOUNT_MANAGER pat

JOIN

INSERTED I ON I.PAT_account_manager_ID = pat.PAT_ACCOUNT_MANAGER_ID

WHERE pat.NAME_ID = i.NAME_ID

AND pat.ROLE_TYPE_ID = i.ROLE_TYPE_ID

AND pat.LOGIN_ID <> i.LOGIN_ID

How would I have to change it to handle multiple records then?

DECLARE @NameID int, @RoleID int, @LoginID char(20)

SET @NameID = (

SELECT

NAME_ID

FROM

inserted

)

SET @RoleID = (

SELECT

NAME_FIELD_NUMBER

FROM

inserted

)

SET @LoginID = (

...

Just a quick scan, you have an update table, which is the same table I am deleting and inserting to, I cant update because there are no unique identifiers. But...

That's why in this case I cant do set base, because I need to use data from other tables as well, not just the inserted data. Well thanks for all...

Sorry:blush: So then I assume that the inserted table does how all the records of you insert a batch?

Just a quick question. In the inserted/deleted tables, does it contain all of the records of the last single transaction made? And if I use set based logic, how...

In this specific situation your will never be able to add more than one, because this trigger is just for two people on a single client, one is a supervisor...

Im not using that @PAMID variable anymore..just forgot to take it out before I posted the code. This trigger will fire for every insert. Is it possible for two or...

Here is my finished code. I have more than one trigger do get the job done, but it is working now. To determine the appropriate value, is just by using...

Here is my finished code. I have more than one trigger do get the job done, but it is working now. To determine the appropriate value, is just by using...

When I take the last delete away, the trigger works perfectly. It adds everything it has to. I would just like it to delete the records from the last table...