Post reply

Strange behaviour of row limit error

  • March 6, 2009 at 10:10 am

    #155383

    here is a simple query

    select * , ROW_NUMBER() over(ORDER BY Addr_city, Comp_CompanyId) AS rowranking

    from sagecrm.vSearchListCompany

    WHERE comp_name LIKE N'us army%' ESCAPE '|'

    and here is a simple error that i am getting when i ran the above query.

    Cannot create a row of size 8094 which is greater than the allowable maximum of 8060.

    but when i use a different column in the order by clause the query works e.g

    select * , ROW_NUMBER() over(ORDER BY Pers_fullname, Comp_CompanyId) AS rowranking

    from sagecrm.vSearchListCompany

    WHERE comp_name LIKE N'us army%' ESCAPE '|'

    i undestand the error but i dont know why i am getting this, and more importantly why i am not getting it for the second case.

    Any help??

    Thanks

    Usman

  • March 7, 2009 at 10:02 am

    #955494

    Where are the gurus??:)

  • March 9, 2009 at 6:20 am

    #955905

    Can you post some data structures and sample data that would allow us to experiment with the data?

    What are the data types and sizes involved? Are any varchar or nvarchar(max)?

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply