It's not all about the OP, you know 🙂

Okay - thanks. I was just checking I wasn't missing something 🙂

I knew I'd get that response...

I prefer a table name of 'Numbers' or 'Integers' - and I like to use 'i' for the column name (for integer).

It's all much of a muchness really.

Q (5/1/2008)

---

Add a column that creates a unique id per row. Select the minimum value into a table for this new column based on the columns that will...

:hehe:

Where there's muck, there's mud......

I like the idea of a generic multi-purpose test table 🙂

I will be steeling that idea 😀

I'm also reminded of this article...

http://www.sqlservercentral.com/articles/Advanced/lookuptablemadness/1464/

There are several discussions on this already on the web. Here's one...

http://www.sqlservercentral.com/articles/T-SQL/61244/

The article is poor, but the discussion is useful.

Try something like this...

declare @t table (a varchar(10), b varchar(200), c varchar(10))

insert @t

select 'Mut1', 'AZ5397UA9,AZ539CYK2,AZ54022Z3,AZ8040BQ1,AZ0442BB0,AZ2404AW1,AZ307TAD0,AZ442FAE8,AZ442FAQ1,AS490FAV1', 'Credit1'

union all select 'Mut1', 'B5397UB9,B539CYK2,B540223,B8040BQ1,B0442BB0,B2404BW1,B307TBD0,B442FBE8,B442FBQ1,BS490FBV1',...

Looks good to me, marcelo.

One typo - jo's empid should be 5 rather than 4

All the solutions are how I would (and did :)) do it, depending on the exact...

OK - just checking 🙂

rbarryyoung (4/30/2008)

---

The problem with the phrase "Remove Duplicates" is that the speaker *usually* means is "one of them is 'real', so the others that are like it are the duplicates,...

Then there's a problem/limitation with the function. I just tested it, and if you change char to varchar it will work...

Try

select * from dbo.fn_split(@facility,',')