CAN ANY SOLVE THIS PROBLEM - SQL Server Forums

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 2000 Forums

SQL Server Development (2000)

CAN ANY SOLVE THIS PROBLEM

Author

Topic

DURGESH
Posting Yak Master

105 Posts

Posted - 2008-07-12 : 06:11:23

hi all,
i am getting following error when i am using inner join in a trigger

UPDATE CLIENTREFDB.DBO.TBL_STDATTRIBUTES SET STDATTRIB_ABBR=B.STDATTRIB_ABBR,
STDATTRIB_DEFINITION=B.STDATTRIB_DEFINITION,
STDATTRIBUTE_TYPE=B.STDATTRIBUTE_TYPE,
SEQNO_PO=B.SEQNO_PO,
SEQNO_SD=B.SEQNO_SD,
FLAG4SD=B.FLAG4SD,
FLAG4PO=B.FLAG4PO,
FLAG4INCLUDEHEADER2PO=B.FLAG4INCLUDEHEADER2PO,
FLAG4INCLUDEHEADER2SD=B.FLAG4INCLUDEHEADER2SD,
FLAG4INCLUDEABBR2PO=B.FLAG4INCLUDEABBR2PO,
FLAG4INCLUDEABBR2SD=B.FLAG4INCLUDEABBR2SD,
MCAMS_GLOBAL_FLAG=B.MCAMS_GLOBAL_FLAG,
MFU_FLAG=B.MFU_FLAG FROM CLIENTREFDB.DBO.TBL_STDATTRIBUTES A INNER JOIN INSERTED B ON A.STDATTRIBUTE=B.STDATTRIBUTE

the error is
error 156 incorrect syntax near from the keyword 'FROM'

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-07-12 : 06:21:04

Try

UPDATE A
SET STDATTRIB_ABBR=B.STDATTRIB_ABBR,
STDATTRIB_DEFINITION=B.STDATTRIB_DEFINITION,
STDATTRIBUTE_TYPE=B.STDATTRIBUTE_TYPE,
SEQNO_PO=B.SEQNO_PO,
SEQNO_SD=B.SEQNO_SD,
FLAG4SD=B.FLAG4SD,
FLAG4PO=B.FLAG4PO,
FLAG4INCLUDEHEADER2PO=B.FLAG4INCLUDEHEADER2PO,
FLAG4INCLUDEHEADER2SD=B.FLAG4INCLUDEHEADER2SD,
FLAG4INCLUDEABBR2PO=B.FLAG4INCLUDEABBR2PO,
FLAG4INCLUDEABBR2SD=B.FLAG4INCLUDEABBR2SD,
MCAMS_GLOBAL_FLAG=B.MCAMS_GLOBAL_FLAG,
MFU_FLAG=B.MFU_FLAG FROM CLIENTREFDB.DBO.TBL_STDATTRIBUTES A INNER JOIN INSERTED B ON A.STDATTRIBUTE=B.STDATTRIBUTE

Madhivanan

Failing to plan is Planning to fail

DURGESH
Posting Yak Master

105 Posts

Posted - 2008-07-12 : 07:04:45

it is showing the same error

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-12 : 07:28:14

Post the full code you use, please!

UPDATE		a
SET		a.STDATTRIB_ABBR = B.STDATTRIB_ABBR,
		a.STDATTRIB_DEFINITION = B.STDATTRIB_DEFINITION,
		a.STDATTRIBUTE_TYPE = B.STDATTRIBUTE_TYPE,
		a.SEQNO_PO = B.SEQNO_PO,
		a.SEQNO_SD = B.SEQNO_SD,
		a.FLAG4SD = B.FLAG4SD,
		a.FLAG4PO = B.FLAG4PO,
		a.FLAG4INCLUDEHEADER2PO = B.FLAG4INCLUDEHEADER2PO,
		a.FLAG4INCLUDEHEADER2SD = B.FLAG4INCLUDEHEADER2SD,
		a.FLAG4INCLUDEABBR2PO = B.FLAG4INCLUDEABBR2PO,
		a.FLAG4INCLUDEABBR2SD = B.FLAG4INCLUDEABBR2SD,
		a.MCAMS_GLOBAL_FLAG = B.MCAMS_GLOBAL_FLAG,
		a.MFU_FLAG = B.MFU_FLAG
FROM		CLIENTREFDB.DBO.TBL_STDATTRIBUTES AS a
INNER JOIN	inserted AS B ON b.STDATTRIBUTE = a.STDATTRIBUTE

E 12°55'05.25"
N 56°04'39.16"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources