Wow! What a comprehensive reply. Nice work, Jeff

You must either have far too much time on you hands or you are a really,...

I didn't know that (about the v9 update) - thanks Tim. The boys at MS have been working hard...

Note that you should run "DBCC UPDATEUSAGE (MyDatabase)" first for Tim's query to be accurate. That is the best method though.

Here's some more ideas for splitting... http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50648 (including the one from Peter above)

Peter - I think I've successfully deduced that you are Peso on SQLTeam

Well, I was enjoying the kind feedback, and then I came across your idea, Peter. Very nice indeed!

I think I've been outdone...

Nagabhushanam Ponnapalli - try adding '1.10' to your data

Here's a (relatively) simple idea/solution with the limitation...

Hi all,

Chris - not wanting to be critical , but more elegantly that what? Those 2 techniques are both listed, along with others, in this link...

Hi Afendi,

Sounds like you're going to need a tally/numbers table. Here's an illustration of the technique...

You may need to use a trigger to...

Good stuff

Post your table structure, some sample data and the result you want for that sample data. Here's an example (for a different question)...

--I...

Hi all,

Tony - it sounds like you only want the ones that have a count of more than one, so maybe you need something like this...

select dbo.uf_stripnonalpha(colname)...

Hi all,

Tryst - You might want to consider storing the lineage (breadcrumb) in a column in your table. These articles endorse that and show you how to do it (again...

Whenever you think about a cursor, slap yourself and tell yourself there must be a better way.

Post your table structure, some sample data...

Also see...

http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50648

http://www.sommarskog.se/arrays-in-sql.html

There are a few methods to do what you need, and this article discusses them and their pros and cons...

http://www.sql-server-performance.com/mm_list_random_values.asp