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.