Comments by rikidev (Top 13 by date)

The fact is that I am forced to use sql server 2014, on my with docker where will run sql server 2017 for the test phase the code runs perfectly without errors!

I was also convinced that the problem was the same so I tried with this type of solution but I always have the same error!

I tried with the solution you wrote but it does not work properly, if I do it I'll invert the first one with the second one

I had already tried this type of solution but it does not work, I'm sorry but I'm not how to explain correctly,I published here an image of the result I should get: https://imgur.com/qBE4Qh4

I read that there is written in the link but I did not understand how to apply it to my query!

Exactly, I do not know how to modify the order by so that line 3 has (DescrizioneDis,CostoUnitario e Quantita) other than empty

then my glare is that in the first image, the problem is that the only lines in correct output are the first and second, the third shows the fields marked in green (in the second image) in line 4 and not in the third

I expressed myself badly, it does not give me errors, the problem is that I am wrong in the ordering of the results in the query! should give me the result that is present in the image: https://i.stack.imgur.com/SnM39.jpg