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...

Yeah, I can't wait until hackers get into car OSs and make the engines quit, shift into reverse on the freeway, floor the accelerator in the driveway, maybe even self-start...

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 would get...

Oh, yeah. Oops. You could use multiple rows and put an...

David Webb-200187 (12/19/2012)

---

You could send a fixed terminating character on the end of your variable parameters and check to see if it is actually the last character in the parameter....

GilaMonster (12/19/2012)

---

pdanes (12/19/2012)

---

Don't you get a performance hit from passing a table over the network, rather than a single string? And I think the server would parse it a lot...

SQLKnowItAll (12/19/2012)

---

Don't you get a performance hit from passing a table over the network, rather than a single string? And I think the server would parse it a lot faster...

SQLKnowItAll (12/19/2012)

---

I would say that in the case where a parameter is passed to the stored proc that does not match the size of a particular column (i.e. a delimited...

Grant Fritchey (12/19/2012)

---

pdanes (12/19/2012)

---

Well, the data structure...