Interesting question, thanks Steve.

Definately learned something.

ChrisM@Work (1/23/2015)

---

SELECT MondaysThisMonth = DATEADD(DAY,n,MondayBeforeFOM)

FROM (

SELECT FirstOfMonth, MondayBeforeFOM = DATEADD(DAY,DATEDIFF(DAY,0,FirstOfMonth)/7*7,0)

FROM (SELECT FirstOfMonth = DATEADD(MONTH,DATEDIFF(MONTH,0,GETDATE()),0)) d

) e

CROSS JOIN (SELECT 7 UNION ALL SELECT 14 UNION ALL SELECT 21 UNION ALL SELECT...

First result from google for Power View:

Power View: Explore, visualize, and present your data

They have also nice examples on the Power View blog from MSDN.

There should be a similar setting...

jeknight44 (1/23/2015)

---

Here is another way to delete dups.

WITH dup

AS (Select Policy, ROW_NUMBER() OVER (PARTITION BY agentnum, policy ORDER BY ( SELECT 0)) RN

FROM dbo.YourTable)

DELETE...

Storing the formula as a string is asking for trouble and it setting you up for an impossible challenge.

As I look at the formulas, there are only three values changing:

(2100*(1-0.0668)*24*mday*10)

I...

I think this is the non-empty behaviour of SSAS.

By default it should not show empty cells.

The following thread explains how you can change this behaviour in Excel:

http://www.sqlservercentral.com/Forums/Topic1085963-17-1.aspx

The easiest solution would be if you had a calendar table.

If not, you can use the following query:

DECLARE @StartDate DATE = '2000-01-01';

DECLARE @EndDate DATE= '2050-12-31';

DECLARE @parDate DATE= GETDATE();

WITH T0 AS...

winston Smith (1/23/2015)

---

Is there a form for MDS & DQS Related questions? I cant see anything obvious so just wondering if im missing something.

If not, is it something that should...

I have an old version of Redgate SQLPrompt running and I also installed Mladens SSMS Tool pack.

The only thing I change myself in SSMS is to make sure CTRL+R works...

In theory SSRS can work with mobile, but you have to take that with a bit of salt.

If you look for interactive reporting, Power View might be a better option.

Nice one to end the week, thanks Steve.

I haven't used IE11 before. Is there a possibility to...

Brandie Tarvin (1/22/2015)

---

So has Microsoft updated the exams to require you to type in T-SQL? Or is it still multiple choice options of code that looks identical but isn't?

And if...

Brandie Tarvin (1/22/2015)

---

So has Microsoft updated the exams to require you to type in T-SQL? Or is it still multiple choice options of code that looks identical but isn't?

And if...