I see your point. My questions was strickly refferring to building a bundle of reports that we then sell as a package to a client.

In that case we grant...

It won't really. The only different it'll make is that now the report is on the web server rather than report server. Still the source is freely available...

Something like this should do the trick.

SELECT COUNT(dtCnts.*) As NbApplications, dtCnts.CntContacts FROM (

SELECT ApplNbr, COUNT(*) As CntContacts FROM dbo.Contacts GROUP BY ApplNbr

) dtCnts

It's the Anakin Skywalker avatar. Back when I set it up everybody where using star wars avatars :w00t:.

But ya I'm young too :-P.

Ok, just make sure that you don't put this into production. Or that if you do that all docids are indexed AND that you warn everybody that this is...

Hmm, can you give me a 50 000 foot review?

I never used ssis but I guess I'd figure it out with a fairly detailed plan.

Awesome. Is it possible to do a similar trick when exporting a report from SSRS to let's say Excel or PDF?

This is where I really hit a wall when...

Care to elaborate or was to posted in the wrong thread?!?

Here's a quick demo. Run this query. Then copy the results of the query and paste it back into ssms and run that query.

declare @docid int

SET @docid =...

You need to use dynamic sql to do this.

Is this something you need to implement permanantly into the system or just something to help you find something you "lost" in...

That won't work, at least in my case, as I needed to concatenate for each group. Myabe it'll help somebody else.

Ninja's_RGR'us (8/13/2010)

---

If that can help, how about the idiot here who just decided to reboot all the servers because 1 SINGLE employee couldn't connect on the network when all the...

If that can help, how about the idiot here who just decided to reboot all the servers because 1 SINGLE employee couldn't connect on the network when all the while,...

Lynn Pettis (8/12/2010)

---

Ninja's_RGR'us (8/12/2010)

---

Lynn Pettis (8/12/2010)

---

CELKO (8/12/2010)

---

tymberwyld (11/10/2008)

---

Along with a lot of other horrible decisions, I am now not allowed to use Negative numbers in any database design. Instead,...

My code would be fast.

If you were to use that code to do a select in the lookup table then you'd get awful performance. In your case you're better...