lmu92 (6/30/2010)

---

chris-736523 (6/30/2010)

---

I do this frequently.

I'll declare the input parameter as

@ParameterName VARCHAR(4000)

Then, whatever is calling the procedure needs to pass a comma delimited string of values. Example ...

I do this frequently.

I'll declare the input parameter as

@ParameterName VARCHAR(4000)

Then, whatever is calling the procedure needs to pass a comma delimited string of values. Example "1,2,3,4,5,6".

In the...

I'm not sure about the first item you mentioned "Re-apply the base SSRS configuration each time in case it was messed-with by a developer", but....

RSBuild is an open source SSRS...

becklery,

Your response is quite lame. Download the RDL is your answer?

Maybe you are just trying to spam the forums with the link in your post?

Jeff,

I...

Thanks for the reply.

I do know what is needed, however, it is quite difficult to find a balance between having enough detail and something that a business user can read,...

Thanks! That worked. It's funny, i tried the exact same thing with exception to one item. I didn't have sp_executesql between exec and @sql, so it was...

Thanks for the reply. BCP seems to be the way to go. The output came out just like I wanted it!

Many thanks! Can I Kudos your message...

In the last part of the code, it's creating a clustered index on a temp table, then immediately dropping it. Why?

That is a nasty procedure. *I* would put debug...

Just thought I would followup on this one in case anyone else has the same issue.

I'm pretty sure this can't be done with an expression without custom code, maybe that...

IMO - Stored procedures are the best.

I keep finding limitations in data manipulation (sums, totals, distinct counts) on the RDL design, so the use of a stored procedure gives me...