Declare @pSortParam varchar(35)

Select @pSortParam = 'BfsXpLogID';

with a as (
Select * from dbo.BfsXpLog a with (nolock)
)
Select * from (Select top 10 * from a where @pSortParam = 'CreateDate' order by CreateDate) as b
union all
Select * from (Select top 10 * from a where @pSortParam = 'BfsXpLogID' order by BfsXpLogID) as b