By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,767 Members | 1,302 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,767 IT Pros & Developers. It's quick & easy.

Multi-part identifier error

P: 41
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
  1. CREATE PROCEDURE GETASSIGNMENTS AS
  2. UPDATE TOP (20) AssignedPages
  3. SET AssignedPages.PageURL = ArmyRootURLPages.PageURL, RoleID = [Form_ArmyWebPages].roleid, PageType = 1
  4. WHERE ArmyRootURLPages.DateReviewed is Null
  5.  
Anyone know what I'm doing wrong?

Thanks
Oct 1 '09 #1
Share this Question
Share on Google+
2 Replies


ck9663
Expert 2.5K+
P: 2,878
Are you updating or inserting?

--- CK
Oct 1 '09 #2

P: 41
Inserting, :(

Figured it out, thanks
Oct 1 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.