You might as well insert the 10 parameters in the tvp (without bothering with ifs) and then use where value is not null in the concat function.

Cadavre (10/26/2011)

---

Ninja's_RGR'us (10/26/2011)

---

Cadavre (10/26/2011)

---

Ninja's_RGR'us (10/26/2011)

---

You can try with

FOR XML PATH.

I've seen that suggested in the past. I don't have a full understanding of what it does so I...

Hence my punching bag idea :-D....

Cadavre (10/26/2011)

---

Ninja's_RGR'us (10/26/2011)

---

You can try with

FOR XML PATH.

I've seen that suggested in the past. I don't have a full understanding of what it does so I recommend you...

Tony++ (10/26/2011)

---

I did make my move 3 months ago. The funny part was that the company I was leaving had a hard time believing that I wasn't leaving for...

Cadavre (10/26/2011)

---

heh. I'll attend...

You can try with

FOR XML PATH.

FOR XML PATH TYPE

I've seen that suggested in the past. I don't have a full understanding of what it does so I recommend...

NP.

Was what so important in that meeting that could make this unbeknownst guy wait for his answer! 😀

You should talk to the authorities about that!

I hit google in case I could find something useful (Paul Randal's posts... as he's the ms guy who wrote the code!).

That thread might help out even if you seem...

SaintGr8 (10/26/2011)

---

Ninja's_RGR'us (10/26/2011)

---

The way I do this without preaggregating everything is with an outer apply.

Works reasonably fast here so I didn't bother trying to find faster way to access the...

The way I do this without preaggregating everything is with an outer apply.

Works reasonably fast here so I didn't bother trying to find faster way to access the data, so...

I...

Why SPACE(0) instead of ''?

P.S. Nice solution ;-).

ChrisM@Work (10/26/2011)

---

Celko's less personally offensive. This guy would benefit from a warning...

derekr 43208 (10/26/2011)

---

Cadavre (10/26/2011)

---

How's this?

DECLARE @sql AS VARCHAR(MAX)

SELECT @sql = COALESCE(@SQL + '; ', '') + sql_command

FROM (SELECT 'USE ' + QUOTENAME(name) +

...