Thanks for the link ... I'm just seeing a blank page.

Hi and thanks very much for that.

It produces in the list column:

1>2

1>2>3

1>2>4

1>2>5

1>2>4>8

1>2>3>6

1>2>3>7>9

1>2>3>7>10

What I need it to produce is:

1>2

1>2>3

1>2>3>6

1>2>3>7

1>2>3>7>9

1>2>3>7>10

1>2>4

1>2>4>8

1>2>5

I've tried various sorting but I can't make it do that. And although...

Steve Jones - SSC Editor (5/9/2012)

---

sku370870 (5/9/2012)

---

You've spend hundreds of hours developing. A lot of your business logic is in your stored procedures and functions. You can't afford SQL Server...

I raised that issue initially and...

stephanie.sullivan (5/9/2012)

---

sku370870 (5/9/2012)

---

You've spend hundreds of hours developing. A lot of your business logic is in your stored procedures and functions. You can't afford SQL Server hosting of your own....

I don't have any developers. I write the lot.

You've spend hundreds of hours developing. A lot of your business logic is in your stored procedures and functions. You can't afford SQL Server hosting of your own. You use...

Thank you to everyone who has replied ... the fog clears a little and, it seems, my lack of understanding is not all down to me.

I wonder if I might...

In my scenario - to stick with the data structure I posted (as opposed to my 'real-world' issue mentioned above) - if I ended up with the situation that OrganisationID...

Thank you very much for taking the time to explain that - and - I understand it!

I will read, re-read and write if for myself with different tables and columns...

Thanks for your help in trying to get me to understand this.

I realise in your code you are doing up update query joining #fred to a table created by this...

Wow, thanks very much. Yes, that's exactly what I need.

Seeing your code makes me realise what a novice I am at this lark.

Can I ask ...

Using that 'With' statement, you...

Thanks for your reply. The .net page in the middle is to present users with a list of contacts that they want to filter ... by ticking check boxes to...

Thank you for all the replies. I have done this sort of 'run a job at night to send some emails' but never more than a few emails at a...

Jeffrey Williams-493691 (8/20/2011)

---

It all really depends on the query that is getting the data and as you pointed out, how that table is used in the application.

I just had to...