whats wrong with this trigger

Question

create

 

trigger formatbilllocation on airtelperiod after insert

as

begin

declare

 

@filelocation varchar(max)

set

 

@filelocation=(select filelocation from inserted)

set

 

@filelocation='\\10.6.14.63\Airtel_Bills\'+@filelocation

update

 

airtelperiod set filelocation=@filelocation where airtelperiodid=inserted.airtelperiodid

end


its giving error  "

The multi-part identifier "inserted.airtelperiodid" could not be bound.

 

"

Answer 1

MY INTENTION IS TO APPEND STRING \\10.6.14.63\Airtel_Bills\  TO THE NEWLY INSERTED VALUE

Answer 2

You need to join airtelperiod table with inserted. Something like this

create trigger formatbilllocation on airtelperiod 
after insert 

as

begin

declare @filelocation varchar(max)

set @filelocation=(select filelocation from inserted)

set @filelocation='\\10.6.14.63\Airtel_Bills\'+@filelocation

update airtelperiod set filelocation=@filelocation 
		from airtelperiod
			join inserted on  airtelperiodid=inserted.airtelperiodid

end

---

Abdallah, PMP, MCTS

Answer 3

You need to join airtelperiod table with inserted. Something like this

create trigger formatbilllocation on airtelperiod 

after insert 



as



begin



declare @filelocation varchar(max)



set @filelocation=(select filelocation from inserted)



set @filelocation='\\10.6.14.63\Airtel_Bills\'+@filelocation



update airtelperiod set filelocation=@filelocation 

		from airtelperiod

			join inserted on  airtelperiodid=inserted.airtelperiodid



end

---

Abdallah, PMP, MCTS

nEW ERROR IS COMING AS "Ambiguous column name 'airtelperiodid'."

Answer 4

Try now

create trigger formatbilllocation on airtelperiod 
after insert 

as

begin

declare @filelocation varchar(max)

set @filelocation=(select filelocation from inserted)

set @filelocation='\\10.6.14.63\Airtel_Bills\'+@filelocation

update airtelperiod set filelocation=@filelocation 
		from airtelperiod
			join inserted on  airtelperiod.airtelperiodid=inserted.airtelperiodid

end

---

Abdallah, PMP, MCTS

Answer 5

Try now

create trigger formatbilllocation on airtelperiod 

after insert 



as



begin



declare @filelocation varchar(max)



set @filelocation=(select filelocation from inserted)



set @filelocation='\\10.6.14.63\Airtel_Bills\'+@filelocation



update airtelperiod set filelocation=@filelocation 

		from airtelperiod

			join inserted on  airtelperiod.airtelperiodid=inserted.airtelperiodid



end

---

Abdallah, PMP, MCTS

THANKS  A TON!!