The first thing that jumps out at me is the

INNER JOIN table3 c ON CHARINDEX(c.Column,a.Column)>0

Joining on a calculated value is just terrible for performance, because you can't index the...

Instead of showing us the code, please post some sample data showing the original structure of your table and then the desired one.

Most helpful would be if you would post...

That VALUES trick is really handy! Absolutely going to steal that!

Rob Collie (PowerPivotPro.com) points out which versions contain the PowerPivot features on his blog here[/url].

Thanks for confusing everyone again, Microsoft. </snark>

Yeah, I would hope so. The "documentation" was absolutely hilarious - I photocopied that page and hung it on my wall. I think I wrote "JOB SECURITY" across the...

USE tempdb;

GO

CREATE TABLE Customer (

CustomerID INT IDENTITY,

FirstName VARCHAR(15) NOT NULL,

LastName VARCHAR(20) NOT NULL

CONSTRAINT pkCustomer PRIMARY KEY (CustomerID) );

CREATE TABLE CustSite (

SiteID INT IDENTITY(100,1),

SiteName VARCHAR(10) UNIQUE NOT NULL,

RelatedCustomerID INT NOT NULL

CONSTRAINT...

Where are you getting the frequency information from? Care to share that part?

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.