Try this:

USE ReportServer

GO

SELECT u.UserName, s.*

FROM subscriptions s

INNER JOIN Users u

ON s.OwnerID = u.UserId

AND u.UserName = 'Jared'

Sean Lange (5/15/2012)

---

SQLKnowItAll (5/15/2012)

---

Hehehe... Because nobody learns them or cares to. I'll tell you a question I have never been asked at an interview... "Are...

Hehehe... Because nobody learns them or cares to. I'll tell you a question I have never been asked at an interview... "Are you familiar with...

So...

SELECT AgencyID, AgencyName,AgencyType, COUNT(AgencyID)

FROM Agencies

WHERE (Grade = 'D' AND PeriodFinishDate > GETDATE() - (365 * 3))

OR

(YEAR(ReportReceivedDate) > YEAR(ReportDueDate) - 3)

OR

(Other= -1 AND OtherReason='High Profile' AND ReportDueDate > GETDATE() - (365...

What is the question?

I'm super confused. Please reference the article in my signature by Jeff Moden, otherwise you are going to get 20 responses that all do something different and none of them...

jralston88 (5/11/2012)

---

So in order for this 'user' to be added - they have to be a "server principal" aka login. Is this correct?

Taking this one step further -...

I don't think anybody's mad. We want to help and, probably more importantly, learn. We just couldn't do much with the error except for take it at its word. Let...

Welsh Corgi (5/15/2012)

---

I'm getting the following error:

The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches ore than one...

sqlvogel (5/15/2012)

---

SQLKnowItAll (5/15/2012)

---

Well, of course it depends... I still don't see your justification for Microsoft having a lot to answer for. Its likes saying that Nissan has "a lot to...

Well, of course it...

Its kind of like asking what's the difference between a salad and a fruit. A salad can be made of fruit or vegetables, and a fruit can be in...

Lynn Pettis (5/15/2012)

---

Eugene Elutin (5/15/2012)

---

...

Now, for whatever reason, Microsoft by default makes it the clustered index. This is 99% of the time wrong.

The clustered index should be on a...

Eugene Elutin (5/15/2012)

---

...

Now, for whatever reason, Microsoft by default makes it the clustered index. This is 99% of the time wrong.

The clustered index should be on a better choice,...

Yes, and as I said there is no mention of these 2 pages. So, if it IS correct I would like someone with...