Multi-part identifier error

jmprescott

Clearly, I don't really know what I'm doing here, but I'm trying to create a stored procedure to grab the top 20 URLs from one table and plug it into another table (along with some other info)

I'm getting an error:

Msg 4104, Level 16, State 1, Procedure GETASSIGNMENTS, Line 2
The multi-part identifier "ArmyRootURLPages.DateReviewed" could not be bound.

Expand|Select|Wrap|Line Numbers

 
CREATE PROCEDURE GETASSIGNMENTS AS

UPDATE TOP (20) AssignedPages

SET AssignedPages.PageURL = ArmyRootURLPages.PageURL, RoleID = [Form_ArmyWebPages].roleid, PageType = 1

WHERE ArmyRootURLPages.DateReviewed is Null

Anyone know what I'm doing wrong?

Thanks

ck9663

Are you updating or inserting?

--- CK

jmprescott

Inserting, :(

Figured it out, thanks

Multi-part identifier error

re: Multi-part identifier error

re: Multi-part identifier error

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about