Interesting... Good to know! So check your indexes, then try each one...

Thanks, Scott!

The code attempts to subtract weekends, holidays...

I would do that part with a Calendar table... then you need pretty much ZERO logic for it.

WHERE Calendar.IsWeekend = False AND Calendar.IsHoliday=False...

You could... but I'd read this first:

http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/

I would have sworn that EXISTS stops as soon as a True/False changes, while an IN reads the whole table. So I would think...

If you're dealing with a star schema, you'd filter the Calendar/Date table and then the join would filter the Fact table.

SELECT ...

FROM FactTable f

INNER JOIN DimDate d

...

What if you shred the XML to a table, and index it? Then the join can use the index for the subsequent query.

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...