p.description,isnull(s.rankcode,9999) as rankcode,
...
order by S.rankcode, p.description, m.matnr
...
Removing the S. in s.rankcode made it work. I understand why. But i don't understand why it
I would suspect the collation in stead of the dblevel.
I notice you've used a capital S and a non-capital s to be used as the columns alias.
Replace the s.rankcode to S.rankcode, and give a little feedback if that has been the issue.
If you would have posted the from-part, that plausibility might be confirmed.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me