Problem with Stored Procedure

From: Phil Grimpo <pgrimpo@xxxxxxxxxxxxxxx>
Date: Mon, 25 Aug 2008 14:50:37 -0500

I have this in my stored procedure:

@PageID INT,
@VersionID INT

UPDATE Pages SET MainData = (SELECT MainData FROM Pages_Archive WHERE PageID = @PageID AND VersionID = @VersionID)
WHERE PageID = @PageID

I get this error: "Error 279: The text, ntext, and image data types are invalid in this subquery or aggregate expression."

MainData is of type "text"

However, I have done this same things before in an INSERT statement. Does it not work for UPDATE?

Thanks.

-Phil

.

Follow-Ups:
- Re: Problem with Stored Procedure
  - From: Bob Barrows [MVP]
- Re: Problem with Stored Procedure
  - From: Bob Barrows [MVP]

Prev by Date: RE: Get a month's days and merge with a table
Next by Date: Re: Problem with Stored Procedure
Previous by thread: Re: What to do when you can't retrieve content from a DB
Next by thread: Re: Problem with Stored Procedure
Index(es):
- Date
- Thread

Relevant Pages

Re: Problem with Stored Procedure
... UPDATE Pages SET MainData = (SELECT MainData FROM Pages_Archive WHERE ... WHERE PageID = @PageID ... Please reply to the newsgroup. ...
(microsoft.public.inetserver.asp.db)
Re: Problem with Stored Procedure
... UPDATE Pages SET MainData = (SELECT MainData FROM Pages_Archive WHERE ... WHERE PageID = @PageID ... I get this error: "Error 279: The text, ntext, and image data types ... Please reply to the newsgroup. ...
(microsoft.public.inetserver.asp.db)