Cannot create a worktable row larger than allowable maximum. Resubmit 1

[Norman55]

i am trying to return a qry on a ASP page and am getting the following error
Cannot create a worktable row larger than allowable maximum. Resubmit your query with the ROBUST PLAN hint.

i am not trying to update the field
the field is nvarchar 4000 and there are only 511 charactors?

 

[foxbox]

Maybe select left(yourField,511) ?
Which DBMS?
"the field is nvarchar 4000 and there are only 511 charactors? "
So why use a nvarchar(4000) field?

 

[foxbox]

Do you have a group by? MS SQL:
"For GROUP BY clauses that do not contain CUBE or ROLLUP, the number of group_by_expression items is limited by the GROUP BY column sizes, the aggregated columns, and the aggregate values involved in the query. This limit originates from the limit of 8,060 bytes on the intermediate work table that is needed to hold intermediate query results. A maximum of 10 grouping expressions is permitted when CUBE or ROLLUP is specified."

maybe post your complete SQL

 

[Norman55]

thank you for your help