Update parent value from child values

• rmcknight

  SSC Eights!

  Points: 918

  More actions

  October 2, 2007 at 6:57 pm

  #118370

  Without cursors, can I concatenate top 30 child values into one parent value within the parent

  Update parent

  Set Parent.value1 =

  ( select top 30 @STR = @STR + child.value

  from child

  where child.key = parent.key

  and child.value <> 'blah'

  order by child.priority

  )

  When thru, ALL parent.value1 fields should contain the concatenated child values.

• Sergiy

  SSC Guru

  Points: 110206

  More actions

  October 2, 2007 at 7:01 pm

  #738462

  You need to create function from your inner query and use it like this:

  SELECT ..., dbo.ConcatCodes(key, 30)

  FROM ParentTable

  _____________
  Code for TallyGenerator