What's wrong with this stored procedure

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff - 28 Apr 2005 16:11 GMT

I get an incorrect syntax error at 'INNER'

CREATE PROCEDURE [SP_UpdateTable] AS
UPDATE TableName INNER JOIN TableName_Audit
ON TableName.[ID] = TableName_Audit.[ID]
SET TableName.[User] = [Allegatiions_Audit].[User],TableName.[Date] =
[Allegatiions_Audit].[Date]

Reply to this Message

Jeff - 28 Apr 2005 16:14 GMT

Sorry, I typed it incorrectly. Should be:

CREATE PROCEDURE SPUpdateTable AS
UPDATE TableName INNER JOIN TableNameAudit
ON TableName.[ID] = TableNameAudit.[ID]
SET TableName.[User] = TableNameAudit.[User],TableName.[Date] =
TableNameAudit.[Date]

Reply to this Message

Kevin3NF - 28 Apr 2005 16:34 GMT

Try this:

CREATE PROCEDURE SPUpdateTable
AS
UPDATE TableName
SET TableName.[User] = TableNameAudit.[User],
TableName.[Date] = TableNameAudit.[Date]
FROM TableName
INNER JOIN TableNameAudit
ON TableName.[ID] = TableNameAudit.[ID]

Signature

Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

> Sorry, I typed it incorrectly. Should be:
>
[quoted text clipped - 3 lines]
> SET TableName.[User] = TableNameAudit.[User],TableName.[Date] =
> TableNameAudit.[Date]

Reply to this Message

Jeff - 28 Apr 2005 17:30 GMT

It works! Thanks,

Reply to this Message