How can I use order by in dynamic query?

Question

Hello everyone,

From this below query, Order by can not working when I am passing parameter @SortColumn. But it working directly passing value. For eg, if I am giving AgencyName asc instead of @SortColumn. Its working fine. How to solve this issue when I am passing parameter?

DECLARE @StartRowNum varchar(10)
DECLARE @EndRowNum varchar(10)
DECLARE @SortColumn varchar(100)
DECLARE @TransId varchar(100)

SET @SortColumn = 'AgencyName asc'
SET @TransId = 1481143433
SET @EndRowNum = 50
SET @StartRowNum = 0

begin

select  ROW_NUMBER() over (order by @SortColumn )  AS RowNum, tempID,ProgramId,ChannelId,Date_DL,StartTime,EndTime,Viewers,
  Tx,TVR,CVR,DVR,
  Details_Id,
   MastersId,BrandsId,ItemsId,Note,PaidForOrProp,Verbal,Indexes,Seconds,
     GradesId,ChannelName,CountryName,WebSiteName,ProductionName,BrandName,ItemName,
     Product_company_id,CompanyName,ProductGroupsId,
     SectorsId,SubSectoresId,AgenciesId,GroupName,SectorName,SubsectoreName,
     AgencyName,agencyID,QualityGrade,CPH_DL,CPH_UN,Country_CPH,Country_UN,
     Web_CPH,Web_UN,
 AdFactor,Duration_Factor,DaypartName,DaypartId,DaypartFactor,CinemaFactor,DigitalFactor,MediaValue from
 dbo.MonitorExposureFinal WHERE Trans_Id = @TransId
 end

Answer 1

Try this. " Salamander .NET Linker and mini-deployment tool allows you to link .NET assemblies together into a single file, and to deploy your application without installation of the whole Microsoft .NET Framework. The linker selectively links MSIL code putting together only the required classes and methods, and it is capable of linking into the Microsoft .NET framework class libraries. The mini-deployment tool then builds a minimum set of the Microsoft .NET runtime to ship with your application. This usually results in installation size of a few mega bytes, rather than tens of mega bytes, and the installation takes much less time without rebooting machines. The mini-deployed application can be launched directly from a CD, absolutely without copying files or adding registry entries." Regards KevinT

Answer 2

thanks for your replies.. i just thought, that it would be possible, to bind the methods and modules which i need into the .exe so that the exe grows, but obviously it is not possible - what a pity thx maschka

Answer 3

Dynamic and static binding are terms of how the libraries of the runtime are loaded at runtime. Neither of these have to do with linking runtime libraries inside the executable.

Answer 4

In the same way that you couldn't run a program coded to the Win API on a non-Windows machine, a program coded to the .NET framework needs the .NET framework.