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.
| Author |
Topic |
|
dbjnj5
Starting Member
1 Post |
 Posted - 2007-10-04 : 16:20:18
|
| I am trying to write my first stored procedure and am trying to follow the flow of another stored procedure. This is the procedureset ANSI_NULLS ONset QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[RepairOrderImport] ASUPDATE RepairOrdersSET uniqueID = P.UniqueID, UnitNumber = P.UnitNumber, SN = P.SN, DateComplete = P.DateComplete, RepairOrderNum = P.RepairOrderNum, ActualCost = P.ActualCost, Comment2 = P.Comment2, Comments = P.CommentsFROM DMSERVER01.tmvpMccandless.dbo.RepairOrderImport AS PJOIN RepairOrders ON SN = P.SNWHERE RepairOrderImport.uniqueID = P.uniqueIDINSERT INTO RepairOrders (uniqueID, UnitNumber, SN, DateComplete, RepairOrderNum, ActualCost, Comment2, Comments, RepairType)SELECT P.uniqueID ,P.UnitNumber, P.SN, P.DateComplete, P.RepairOrderNum, P.ActualCost, P.Comment2, P.CommentsFROM DMSERVER01.tmvpMccandless.dbo.RepairOrderImport AS PLEFT JOIN RepairOrders ON uniqueID = P.uniqueIDThis is the error I get when I run itMsg 107, Level 16, State 3, Procedure RepairOrderImport, Line 8The column prefix 'RepairOrderImport' does not match with a table name or alias name used in the query.Msg 209, Level 16, State 1, Procedure RepairOrderImport, Line 17Ambiguous column name 'uniqueId'.I know I have a long way to go, but would appreciate any help.Thanks, |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-04 : 18:08:56
|
| Try this:UPDATE RepairOrdersSET uniqueID = P.UniqueID, UnitNumber = P.UnitNumber, SN = P.SN, DateComplete = P.DateComplete, RepairOrderNum = P.RepairOrderNum,ActualCost = P.ActualCost, Comment2 = P.Comment2, Comments = P.CommentsFROM DMSERVER01.tmvpMccandless.dbo.RepairOrderImport AS PJOIN RepairOrders R ON R.SN = P.SNJOIN RepairOrderImport O ON O.uniqueID = P.uniqueID |
 |
|
|
|
|
|
|
|
Stored Procedure