User Profile

Collapse

Profile Sidebar

Collapse
fclanton
fclanton
Last Activity: Dec 29 '07, 06:12 AM
Joined: Dec 27 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • fclanton
    started a topic error Msg 279, Level 16, State 3

    error Msg 279, Level 16, State 3

    when i run this query ......

    update item set description=(se lect description from item where itemid=5384);

    i get this error message...

    Msg 279, Level 16, State 3, Line 1
    The text, ntext, and image data types are invalid in this subquery or aggregate expression.

    there is a lot of text in the description column of itemid 5384 (html coding) and i need to set all of the records in the...
    See more | Go to post

  • fclanton
    started a topic update using data from table

    update using data from table

    my item table looks like this:

    itemID name description
    1 coin1 good coin
    24 coin2 bad
    35 coin3 bad
    48 coin4 bad

    i need to use the description in row one to update the other records to read the same as row 1

    it would then look like this...

    itemID name description
    1 coin1 good coin
    24...
    See more | Go to post
No activity results to display
Show More
Working...