SQL Server Query

• niteen2009

  SSC Veteran

  Points: 299

  More actions

  January 13, 2011 at 3:07 am

  #146839

  Hi Experts,

  I want reuslt something like,

  suppose there is sql query which returns employee names in employee table.

  I am passing employee name to that query. i want to show this passed employee name on the first row and then other rows.

  for ex. i am passing 'ron' then result set should like this..

  ron

  tango

  danny

  amo

  Please help me..

  Thanks in advace.

• davidandrews13

  SSCertifiable

  Points: 6820

  More actions

  January 13, 2011 at 7:17 am

  #1273018

  declare @table table(id int ,name varchar(50))

  insert into @table

  select 1,'ron'

  union

  select 2,'tango'

  union

  select 3,'danny'

  union

  select 4,'amo'

  declare @param varchar(50) = 'tango'

  select id,name from

  (

  select

  * ,

  case when name = @param then 1 else 0 end as customSort

  from

  @table

  )x

  order by customSort desc

  like this?

• niteen2009

  SSC Veteran

  Points: 299

  More actions

  January 13, 2011 at 7:36 am

  #1273033

  Thank you sir. I want like this. Thank you very much.