Error message: The text, ntext, and image data types can not be used

[SundancerKid]

I am receiving the following message:

The text, ntext and image data types can not be used in a Group by clause.

I upgraded from version 7.5 of Great Plains to Version 8.0. The SQL views and Stored procedures created in the 7.5 version should work. I restored the database with another name and the views and SP work fine, but I need to move forward. We are running MS SQL 7 with SP4.

Thanks


RP

 

[SQLBill]

As a suggestion, you might want to post in the Great Plains forums.

Forum632 - Great Plains solutions
Forum1347 - Great Plains - Vision suite

-SQLBill

Posting advice: FAQ481-4875

 

[SQLBill]

I should clarify my response...I can't find anything in the BOL that says you can't use those in a GROUP BY. However, while it uses a SQL Server database, Great Plains software has differences in the SQL it uses.

-SQLBill

Posting advice: FAQ481-4875