CirquedeSQLeil (8/10/2010)

---

Brandie Tarvin (8/10/2010)

---

GilaMonster (8/10/2010)

---

Soft brown sugar. Don't know what name it goes by...

GPO = Group Policy Object.

IF it's asking for windows credentials, then there could be 2 issues going on here. 1) someone changed the security settings on your...

IT seems to me you might be able to accomplish by modifying the aspx pages that run the report manager, though note that any upgrades/service packs etc might break it....

I guess one of the biggest things you need to determine is which set of credentials is it asking for? Is it asking for their windows credentials so that...

Perhaps in SSRS 2008 you may have access to be able to find a count of the first dataset so that you don't need the second one. I'm just...

I take it by the question you are displaying the parameters that were chosen on the report someplace? the header perhaps? At least in SSRS 2005 you can't access...

Probably the easiest way would be for your to spring to Enterprise edition so that you have access to data driven subscriptions. Failing that however you should be able...

This website would be a pretty good place to start... Or you could just follow the wizard in BIDS.

http://msdn.microsoft.com/en-us/library/ms170246.aspx

-Luke.

Tom.Thomson (7/26/2010)

---

bitbucket-25253 (7/26/2010)

---

webrunner

Easy enough to find out ...

CREATE TABLE #T(userid INT)

INSERT INTO #T

SELECT 1 UNION ALL

SELECT 1 UNION ALL

SELECT 2 UNION ALL

SELECT 3 UNION ALL

SELECT 4 UNION ALL

SELECT...

webrunner (7/26/2010)

---

Good question, interesting to learn that the parentheses make no difference for SELECT DISTINCT.

I have one question, though. I've seen people show me queries where they write SELECT...

Alvin Ramard (7/23/2010)

---

CirquedeSQLeil (7/23/2010)

---

Lynn Pettis (7/23/2010)

---

Fun time right now, putting together a list of tasks I should try to complete before COB 2010-08-06. Not really that long, yet, but...

Congrats Lynn, Good luck with the new gig.

-Luke.

Spot on Jeff as always. For those who want to explore this topic a bit more, Gail Shaw wrote a series of blog posts about Joins vs. In vs...

There are a couple of ways to do it, first, you could just do the pivot in your Stored Procedure or SQL Code for your dataset. This would limit...

Again, you're probably bumping up against some timeout somewhere along the lines, or perhaps even running the server/workstation out of disk space as it tries to create a really big...