Can't think of anything to add to this one, just congratulations. Pulling off a stunt like that has got to be a pretty major ego boost.

Thanks, Erin, that does indeed produce exactly what I need (except for the trailing separator, of course). I've been experimenting with both the self-join and FOR XML stuff today, and...

Yes, Erin, that's the kind of thing I'm looking for. I've used the for xml path('') syntax before, but I don't really understand what it's doing very well. I just...

Sean Lange (3/11/2013)

---

You could use a recursive cte to navigate through your table. This is not the fastest methodology but would be faster than a cursor in most cases. Maybe...

It's not obsolete if it still does the job it was designed to do. I've written my share of FORTRAN, RPG, COBOL and who knows what else over the years....

Bill Wehnert - The Tom Swift books (I had a set, too) weren't written by Asimov. http://en.wikipedia.org/wiki/Tom_Swift

I've been a gadget-geek all my life, since I was a little kid, dismantling...

Argh, never mind. Your comment about schemas bumped me in the right direction.

<shame-faced confession>

I was calling the correct procedure name, but from the wrong schema.

</shame-faced confession>

Thirty lashes with a wet...

Lynn Pettis (12/21/2012)

---

To paraphrase the problem originally posted. I have a parameter @MyParameter in a stored procedure that is defined, for example, as varchar(100). Occasionally the string value...

I meant putting all DIFFERENT TYPES of values together into a single string. As you...

Eugene Elutin (12/21/2012)

---

If your input parameter is just a list of character-separated values, then you can make it just VARCHAR(MAX), then use split function to split it into table inside...

Lynn Pettis (12/21/2012)

---

Eugene Elutin (12/21/2012)

---

If your input parameter is just a list of character-separated values, then you can make it just VARCHAR(MAX), then use split function to split it into...

GilaMonster (12/21/2012)

---

Neither Grant, Jared or myself suggested a 'normal' table. We...

Lynn Pettis (12/21/2012)

---

pdanes (12/21/2012)

---

That what I said, I think. This string:

'1E,D,E,Es,F,Fs,G,Gs,H,Hs,J,K,Ks,L,Ls,Lc,M,Me,N,Ns,O,Os,Ob,Oc,P,Ps,Pa,Pb,Pc,R,Ra,S,Ss,Sb,Sc,T,Ts,Ta,Tb,Tc,Ua,Ub,Uc,Va,Z,Zs'

Would instead get passed...

That what I said, I think. This string:

'1E,D,E,Es,F,Fs,G,Gs,H,Hs,J,K,Ks,L,Ls,Lc,M,Me,N,Ns,O,Os,Ob,Oc,P,Ps,Pa,Pb,Pc,R,Ra,S,Ss,Sb,Sc,T,Ts,Ta,Tb,Tc,Ua,Ub,Uc,Va,Z,Zs'

Would instead get passed as a table:

KatalogLetter...

GilaMonster (12/20/2012)

---

pdanes (12/19/2012)

---

GilaMonster (12/19/2012)

---

pdanes (12/19/2012)

---

But what about such a table as a parameter? No business logic, but at least the fields would be strongly typed. I don't know if I...