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
Go to Top of Page

DURGESH
Posting Yak Master

105 Posts

Posted - 2008-07-12 : 07:04:45
it is showing the same error
Go to Top of Page

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"
Go to Top of Page
   

- Advertisement -