Convert ColumnValues to a row.

• Hafeez Mohamad

  Newbie

  Points: 1

  More actions

  June 6, 2011 at 10:19 am

  #239371

  Query:

  -------

  SELECT RoleName FROM ROLES

  Output:

  --------

  RoleName

  ---------

  Admin

  User

  Process Query:

  ---------------

  DECLARE @Roles VARCHAR(100)

  SET @Roles=''

  SELECT @Roles=@Roles+','''+RoleName+''' '''+ RoleName+''' ' FROM Roles

  Print @Roles

  SET @Roles=STUFF(@Roles,1,1,'')

  Print @Roles

  EXEC ('Select ' + @Roles)

  Output:

  --------

  Admin User (Column Names)

  -------------

  Admin User (data in the form of row)

• Orlando Colamatteo

  SSC Guru

  Points: 182276

  More actions

  June 6, 2011 at 10:31 am

  #1334519

  What is your question?

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato