Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) attempt to sort an SQL...

attempt to sort an SQL view gives unexpected results

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello Everybody.

We are working with GP10 and we are trying to build a little solution using manufacturing table PK010033 and some eXtender fields and other data stored in SQL tables.

To consolidate the data we built a view that joins all the various tables and views -

We want to sort the view based on the ITEMNMBR field in table PK010033.

Everything seems right, until we scroll pretty far down the output, and then we notice some lines are not in the proper sort order, but cannot figure out why.

We have tried everything we can think of, but no luck so far.

Any ideas? or suggestions what we might try?

Thank you,

Maria.

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Andrew John Dean 1,337 on at

Like (0)

Report

Re: attempt to sort an SQL view gives unexpected results

Is the 'order by' internal to the view or 'external'. Having the 'order by' internal to the view does not guarantee that the result set will be sorted correctly. To ensure it is sorted correctly try using TOP PERCENT 100 inside the view. If you are doing the 'order by' external ie. select * from view order by col then I don't know what would be causing the problem.