Scott Murray-240410 (8/8/2013)

---

in 2008r2, I was able to add an image link to the folder.aspx page which then shows on the home page. Of course this item is not...

You'll need something like:

SUM(CASE WHEN C.Contact_Date = MT.[Date of Expense] THEN 1 ELSE 0 END)

What I usually to is create a quick analysis in the cube browser, and then recreate the same data in SQL. (the ROLLUP function can be useful to calculate totals...

There's maybe a reason why you cannot do this: you are not the admin.

Granting members to the db_owner rule is making them admin on that database.

If you want to do...

It seems you do not have the permissions to add a new member to the db_owner role (which is the most priviliged role on the database level).

Are you an administrator?

Is a claim bound in any way to a policy? If yes and claim is just a smaller level of detail of a policy, than I would create just one...

You can use the UNION ALL component to get the results of the three sources together.

After each source, you can use a derived column component to add the T-Type column.

I would think Developer would be enough, but I'm not a licensing expert.

IT researcher (8/8/2013)

---

We tried to implement it.But if inner transaction gets commit first.I want inner transaction to roll backup...

Jeff Moden (8/7/2013)

---

Sean Lange (8/7/2013)

---

You might also click on the Stairways over on the left side. There are a number of series that start out basic and get more advanced...

Try this:

DECLARE @buyer VARCHAR(10) = '12, RRRRR';

SELECT CAST(SUBSTRING(@buyer,1,CHARINDEX(',',@buyer,0) - 1) AS INT)

Linked servers bring a whole world of pain with them.

The lookup solution will be more performant.

That book is just an introduction to the concepts, it doesn't contain enough detail to get you through the exams.

I didn't do the 70-457 exam, I did the 3 exams...

I think one of my first "eureka" moment - as Jeff calls it - was when I read Jeff's article about the Tally table 😀 The "Numbers" or "Tally" Table:...

The correct term is "flattening the parent-child hierarchy" 🙂

Anyway, this thread holds some solutions:

http://www.sqlservercentral.com/Forums/Topic1071035-392-1.aspx