Thanks for your reply. I tried it ... C:\MyFolder has one file in it.

The temp table ended up with one column called 'Files' with 11 rows in it showing ...

Volume...

This is a one time import.

I have saved the Excel file as a csv file and tried to import it.

I have set all the fields in the table that is...

Jeff Moden (5/31/2013)

---

I guess the next question would be, why did you put leaders and followers in separate tables? It's a lot easier to manage such things if they're...

Ed Wagner (5/31/2013)

---

I think this is what you're looking for.

SELECT l.LeaderID, l.leader, m.memberid, m.member, ROW_NUMBER() OVER (PARTITION BY l.leader ORDER BY l.leader)

FROM #tblLeaders l

INNER...

Thanks for that, it does the job.

Edit - sorry, this comment was directed to Nick_UK - but it didn't appear where I expected.

Thank you very much for your help. I was under the impression that after using a CTE, you had to SELECT from it. I didn't realise you could create multiple...

Hi, and thank you for your answer.

Following Jeff Moden's answer (and link) - I modified my code to have a sort key that ended up returning...

\6

\6\7

\6\7\12

\6\7\8

\6\7\8\13

... which seems to do...

Ahhhh! Thank you, thank you and thank you again.

Spent most of the weekend on that and today. I've got a bin full of paper with drawings of little tables with...

I see 45 people have looked at this ... but no comments.

Is my question not clear? Or am I going about it the wrong way? Any comment at all? If...

Thanks for that, I'll give it a try.

Thanks very much - as you say, that does the job.

Worst case will be maybe 500 rows - so I'm sure performance won't be an issue.

Thanks again.

Thanks for the input so far - as you say, the code so far does not produce the right order.

I've been playing with an awful mess of cursors and temporary...

Thanks again guys.

As a matter of interest - the real world scenario is a maximum of 5 templates.

Each template has 15 to 20 blocks.

Each block has anything from 1 to...

That does the job too. Again, thanks very much.

Just wish I understood both the solutions that work.

That does the job. Thanks very much.