Group using column name or table attributes

• mtraore08

  Right there with Babe

  Points: 771

  More actions

  July 3, 2011 at 8:41 pm

  #243472

  Hello expert,

  is it possible to create a grouping object based on column name in table?

  I have for instance a table: Activities and 4 columns: Labor, Fabrication, Transport, Distribution.

  I would like to create an object which will group those columns into Manufacturing und Distribution, e.g:

  CASE WHEN Activities.ColumnName = 'Labor' THEN 'Manufacturing'

  CASE WHEN Activities.ColumnName = 'Fabrication' THEN 'Manufacturing'

  CASE WHEN Activities.ColumnName = 'Transport' THEN 'Logistik'

  CASE WHEN Activities.ColumnName = 'Distribution' THEN 'Logistik'

  END AS Activity

  How could I do it?

  Thanks

  mtraore

• Orlando Colamatteo

  SSC Guru

  Points: 182276

  More actions

  July 5, 2011 at 4:36 pm

  #1348660

  Please post DDL, DML to create sample data, expected results and what you have tried so far.

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