You're absolutely right!

This one works:

ALTER TRIGGER [dbo].[ORDERS_tg]

ON [dbo].[ORDERS]

AFTER INSERT,UPDATE

AS

BEGIN

SET NOCOUNT ON;

IF UPDATE (PART_ID)

UPDATE o

SET CODE = m.CODE

,SIZE = m.SIZE

FROM ORDERS o

INNER JOIN Inserted i...

Hi John, sorry if I confused you.

My 1st post indicate the tables(MASTERS and ORDERS) and data of the database.

The MASTERS table already have some data just like this:

INSERT INTO MASTERS

VALUES...

Data on CODE and SIZE are just repeating.

saw that one. That's great.

one more thing, I need to make a inner join on MASTERS.PART_ID = ORDERS.PART_ID AND MASTERS.CODE = ORDERS.CODE

Doesn't seem to work, I'll try to modify it and see what happens.

Thanks

Got it, forgot to put mt on the CASE statement.

Now its working fine and as expected. Thanks

ALTER TRIGGER [dbo].[linecbm] ON [dbo].[SALES_ORDER_LINE]

AFTER UPDATE

AS

IF UPDATE (DRAWING_REV_NO)

UPDATEmt

SETmt.HEIGHT =

CASE

WHEN mt.DRAWING_ID = 'set'...

I see, CASE is a better option.

getting an error: Ambiguous column name 'DRAWING_ID'

its always 1

Guys, thanks for the help. I'ts working now.

I changed my code to this:

ALTER TRIGGER [dbo].[boxqty]

ON [dbo].[PACKAGING]

AFTER INSERT, UPDATE, DELETE

AS

WITH BX AS (

select PACK_ID from inserted

...

I've tried this but cannot seem to make it work.

CREATE TRIGGER boxqty

ON PACKAGING

AFTER INSERT, UPDATE, DELETE

AS

WITH BX AS (PACKAGING

select PACK_ID from inserted

union

select...

Possible Values:

1/1

1/2

1/3

1/4

1/5

1/6

1/8

2/1

3/1

4/1

5/1

6/1

7/1

8/1

I'm thinking about CASE statement for e lesser code. What do you think?

mhike2hale, the code is working fine.

But, what if the data inputted on PACK_TYPE has been changed? Like 2/1 4/1...

The computed column will always detect 1

How can i make it recognize...

I've tried it but i'm having difficulties building a formula.

Can you please show me how?

thanks

Table Build:

CREATE TABLE PACKAGING

(RECORD_ID INT IDENTITY(1,1) PRIMARY KEY,

PACK_ID varchar(4),

BOX_QTY numeric(10,0)

Data:

use TEST01

insert into PACKAGING

values('1/1', NULL)

insert into PACKAGING

values('1/2', NULL)

insert into PACKAGING

values('1/3', NULL)

insert into PACKAGING

values('1/4', NULL)

insert into PACKAGING

values('1/5',...