Compute By used with substring

• Andy.Roberts

  SSC-Addicted

  Points: 442

  More actions

  October 22, 2010 at 8:42 am

  #1240966

  I used a subquery as a way round the problem (as follows) but is there a better solution?

  Selecttables, count(*) 'count'

  from(selectsubstring (so1.name, 1, 50)'tables'

  fromsysobjectsso1

  Whereso1.name like 'mf%'

  Group By so1.name)tbl

  group bytables

  order bytables

  Compute sum(count(*)) by tables

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

  “Doubt is not a pleasant condition, but certainty is absurd.” Voltaire