Thanks, it worked perfectly!

This is very useful answer. But I have a question. I believe -1 means it is not ordered. So should it be

order by case when PurchaserID <> @LoggedIn then...

Yes, It is working. Thank you so much!!

The ArticleType column will contain either "StepByStep" or "Regular" values only. It will not have the value "All"

Thanks

Hi bitbucket,

I get your point. But my question is very simple - just how to rewrite the query. While table defenition may help a little bit, in my humble opinion,...

Hi SunitaBeck,

Thanks for the help. The reference you have mentioned was extremely good!

Thanks

Hello Chris_n_Osborne,

Your assumption is correct and thank you so much for your code snippet. I was able to solve my issue. I agree with you that the table structure needs...

Unfortunately the choice of EAV was made by someone else, higher up. I could only curse him, but somehow make it to work 😉 Based upon a reply from another...

Unfortunately I could not normalize the table. I have to resolve it either at the select statement level or in the C# code.

Thanks

Thanks. That resolves my question.

Thanks