My guess is that you would have to use a stored procedure and check for existence before doing your insert(s). The problem is that you can't declare something has...

If you're importing from an .MDB (as opposed to an .ACCDB) file, I'd use the JET 4.0 drivers.

What version of SSRS were the failing reports built with?

Loop through Excel Files and Tables by Using a Foreach Loop Container

I'm just slow...

This worked:

HighestGrades = SUMMARIZE('Toxicity'

...

Can't really answer all your questions...

If you have something other than a free version of SQL Server, use SSIS to clean your data prior to writing it to your database.

Tools......

I'm okay at SQL, so I sort think of DAX in terms of SQL, which is clearly not the best way to do it. Might have to re-read all...

happycat,

I was wondering how to do it in DAX without "cheating" (well, if you read Rob Collie's book, he does everything explicitly).

The basic idea of what I wanted was basically...

Did you look at the execution plan for the SQL statement? It should tell you where the problems are.

If you're using scalar functions in there, then that could be a...

there's no information on the structure of your function. What does your function do?

Not sure what you mean by "executing functions from Table column"... The solution to this might...

The sample data doesn't make much sense... how a school could accept more people than applicants is a big weird, but anyway...

CREATE TABLE Applications(

AcadYr INT,

Accepted INT,

Applied INT);

GO

INSERT INTO Applications(AcadYr,Accepted,Applied)

VALUES (2010,100,400),

(2011,200,300),

(2012,300,200),

(2013,400,100);

SELECT...

Got Google?

http://www.techrepublic.com/blog/windows-and-office/send-an-email-with-an-attachment-using-powershell/

took maybe 15 seconds

I think it would be something along the lines of

CALCULATE ( [Total Sales],

DATESBETWEEN(DATEADD("week",-6,Calendar[Date]),Calendar[Date]) )

Super convenient that it's called REPLACE in T-SQL and something entirely different in .NET/SSRS, right?

I ended up with this:

=Replace(UCase(Fields!AcctStatus.Value),"CANCELLED","<span style='color:red;'>Cancelled</span>")

Maybe I'm doing it wrong, but it would be super handy...

Now I'm confused. LIKE is a SQL keyword. AFAIK, you can't use it in SSRS.

If you're trying to color the word "cancelled" red, then you could do something like...