Calvin - nested loops - makes me want to go write VB...

Regards

k2

Thanks, Calvin - responses like yours are why I'm addicted to this site - I'm self-taught, and am constantly learning things that make me want to go back an rewrite...

To do it without a cursor, try this:

Drop Table#table1

Create Table#table1(Number int, Name_ varchar(50))

Insert #table1 Values (1, 'ee,ed,ff,er,fsd')

Insert #table1 Values (2, 'rr,kk')

Drop Table#table2

Create Table#table2 (Number int, Name_ varchar(10))

Declare@RowCount int

Set@RowCount = (Select...

A followup question - in QA, will queries separated by the batch separator run consecutively or concurrently? In other words, can I rely on the first being complete before...