Hi, thanks for the input 🙂

Nice article, looking forward for the rest !!

Hehe, great 😀

As mentioned above, wouldn't be easier to use COALESCE? You dont't nedd to worry about trailing comma.

Well, not really useful, since it doesn't support brackets.

Draft send by Rajganesh on the other hand doesn't support decimals. (of course, I can force it)

Don't have time right now to...

Yeah, I've just solved the issue 😀 You advice about NULL pointed me to the solution. It's works perfect if there is no null value is query result. How simple...

Hi, thanks for your response, but since multivalued parameter can't be null-able, this workaround probably won't solve my issue.

I'll try to be more specific.

1. Create simple report with one dataset...

Chris Morris-439714 (9/22/2010)

Wow, you rock!!! Just getting into tally tables and will take a deeper look on them...

Well, primary is question directed to SQL 2005. I'll be more specific:

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL

...

Yeah, not nice solution. Anyway, I'm stuck too to do such.

Something looking pretty useful was posted on other forum:

CREATE TABLE X_REPLACEMENTS (

string NVARCHAR(100),

replacement NVARCHAR(100));

INSERT INTO X_REPLACEMENTS VALUES ('abc','123');

INSERT INTO...

Nice article, thx !! Althought all tips are pretty well known, it's nice have them at one place and check if one didn't forget anything:)

Yeap, pretty cool, thx 😎

But in my real world scenarios, i need get references from referenced tables too. But this is a nice peace of work to start 🙂

I found EXCEPT and INTERSECT very useful many times, although ,as is written in article, it makes the same like NOT IN (resp. IN). For me, they are much more...