Thx Gail,
you are the second, who advice me for not use dynamic code
i'am a beginner and every advice is very welcome,
So i go try one other solution...

Thx John
you helped me very fast,
and i go try to do something on this injection,

Dear John 
i  try only to look in the table @dbname
without the variable 

February 5, 2018 at 8:17 am

#1978557

Thx mr Eriksson for your quickley reaction
15 years ago i create 1 app in Delphi with foxpro as database
now i wil create this in VB.net and Sql Server

Thx Cris for this good and quickly reaction
ORDER BY CASE @id WHEN 1 THEN varieteit ELSE stockeerder END DESC
I hav done what you proposed ans it works very...

Sorry for my bad first question, i hope that i follows the rules now😉
--===== If the test table already exists, drop it
  IF OBJECT_ID('TempDB..#Multisorting','U') IS NOT...