Cannot sort a row of size 8130, which is greater t

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Cannot sort a row of size 8130, which is greater t

Author

Topic

sri_kumar_4u
Starting Member

1 Post

Posted - 2010-03-29 : 03:18:35

Hello All,

SELECT DISTINCT tblJobReq.JobReqId 
              , tblJobReq.JobStatusId 
              , tblJobClass.JobClassId 
              , tblJobClass.Title 
              , tblJobReq.JobClassSubTitle 
              , tblJobAnnouncement.JobClassDesc 
              , tblJobAnnouncement.EndDate 
              , blJobAnnouncement.AgencyMktgVerbage 
              , tblJobAnnouncement.SpecInfo 
              , tblJobAnnouncement.Benefits 
              , tblSalary.MinRateSal 
              , tblSalary.MaxRateSal 
              , tblSalary.MinRateHour 
              , tblSalary.MaxRateHour 
              , tblJobClass.StatementEval 
              , tblJobReq.ApprovalDate 
              , tblJobReq.RecruiterId 
              , tblJobReq.AgencyId  
 
FROM ((tblJobReq  
    LEFT JOIN tblJobAnnouncement ON tblJobReq.JobReqId = tblJobAnnouncement.JobReqId)  
    INNER JOIN tblJobClass ON tblJobReq.JobClassId = tblJobClass.JobClassId) 
 
    LEFT JOIN tblSalary ON tblJobClass.SalaryCode = tblSalary.SalaryCode  
 
WHERE (tblJobReq.JobClassId in (SELECT JobClassId  
                                from tblJobClass  
                                WHERE tblJobClass.Title like '%Family Therapist%'))

When i try to execute the query it results in the following error.

Cannot sort a row of size 8130, which is greater than the allowable maximum of 8094
I checked and didn't find any solution. The only way is to truncate (substring())the "tblJobAnnouncement.JobClassDesc" in the query which has column size of around 8000.

Do we have any work around so that i need not truncate the values. Or Can this query be optimised? Any setting in SQL Server 2000?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-03-29 : 03:53:17

whats the datatype of JobClassDesc? do you have any index in table which involves this column?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources