LOL...

<insert TERRIBLE advice here> ... and don't forget to ascribe to someone who actually knows what he's talking about.

Sorry, couldn't resist!

The question reminded me of some "documentation" of a database...

This is a great discussion on triggers.

Here's the MS page on creating triggers. https://msdn.microsoft.com/en-us/library/ms189799.aspx

Edit - just looked around here and Dwain Camps wrote a great article on triggers[/url]. Definitely worth...

Welcome to SSC. Thanks for the CREATE TABLE and INSERT scripts... they're easier to use if you post them this way, though:

CREATE TABLE Employee(

EmployeeID INT PRIMARY KEY,

EmployeeName VARCHAR(20) NOT...

GoogleFu must be broken... There's a bunch of documentation on the MS website... <putting on my pointy hat D-U-N-C...>

http://social.technet.microsoft.com/wiki/contents/articles/677.power-bi-data-analysis-expressions-dax-language.aspx

JOIN()?

multiple values where? In a multi-select parameter? In your report somewhere?

(Makes me think this place needs a "canned response macro"... )

😀

Got table definitions? Sample data? (Create table and insert scripts)... can be completely fake, just representative.

One thing I would definitely suggest is collecting a list of common questions that you're going to ask of your database, and test your design by trying to answer the...

No wonder I'm so good at SSRS...

"I'll take cryptic UI for 1000!"

You might find this article helpful:

Unpivot a Table Using Cross Apply[/url]

I'm pretty sure I asked a question like this a while back, and the trick is to use dynamic SQL...

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