Msg 4104, Level 16, State 1, Line 1 The multi-part

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Msg 4104, Level 16, State 1, Line 1 The multi-part

Author

Topic

deepckc1
Starting Member

3 Posts

Posted - 2011-12-07 : 01:07:21

here is the script i am using.

UPDATE DB_subcountsnov11new
SET CTM_TYP = AdvDbPRD.dbo.CDSCTM_M.CTM_TYP
from DB_subcountsoct11new
Join AdvDbPRD.dbo.CDSCTM_M
on DB_subcountsnov11new.CTM_NBR = AdvDbPRD.dbo.CDSCTM_M.CTM_NBR

error msg :Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "DB_subcountsnov11new.CTM_NBR" could not be bound.

Pls help me..

Thanks,

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-07 : 01:10:26

it should be


UPDATE n
SET n.CTM_TYP = c.CTM_TYP
from DB_subcountsnov11new n
Join AdvDbPRD.dbo.CDSCTM_M c
on n.CTM_NBR = c.CTM_NBR

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

deepckc1
Starting Member

3 Posts

Posted - 2011-12-07 : 01:14:27

Thanks very much !

quote:
Originally posted by visakh16

it should be

UPDATE n
SET n.CTM_TYP = c.CTM_TYP
from DB_subcountsnov11new n
Join AdvDbPRD.dbo.CDSCTM_M c
on n.CTM_NBR = c.CTM_NBR

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-07 : 01:23:06

wc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

mana
Posting Yak Master

102 Posts

Posted - 2014-07-22 : 06:35:40

i have the following code but i have the below error:
Msg 4104, Level 16, State 1, Line 4
The multi-part identifier "OrderLineItemTransaction.OrderLineItemTransaction ID" could not be bound.

insert into AMPPU_ARTPU(summeofrepairtime,[offline date])
(select SUM(Reparatur_hr)*60,Offline_date from AMPPU_Alle_Fehlteile
group by Offline_date);

update AMPPU_Alle_Fehlteile
set
summe = (select summeofrepairtime from AMPPU_ARTPU)
where AMPPU_Alle_Fehlteile.Offline_date = AMPPU_ARTPU.offline_date1;

can you help me please?

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2014-07-22 : 08:13:47

see http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=195313

When you want to ask a question, it is better to just start a new thread than resurrecting old threads.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources