Traditional approach:

SELECT c.Customer, o.*

FROM dbo.Customers AS c

INNER JOIN dbo.Accounts AS a

ON c.ID = a.CustomerID

INNER JOIN dbo.Orders AS o

ON a.ID = o.AccountID

WHERE c.Inactive = 0

AND...

Looking at the original query it is very de-normalized and almost looks like a pivot table in its own right so the first thing i did to accomplish the task...

I will try to work something up but with out sample data it will take a little longer as i will need to generate some. As far as aggregating...

I would recommend reading Jeff Moden's Cross tab and Pivot articles. Number 1 is http://www.sqlservercentral.com/articles/T-SQL/63681/

ill add a little of my view to sean's. in an OLTP (Transaction) system i would say it would be very limited where i would de-normalize, i would not...

Great sample data. i have a question, how do you know there will only be 12 ExternalID's? is that a business rule. how will you deal with...

is the code you posted generating the alerts or what you are running to find the blocking every 3 min? if its one or the other the other half...

ScottPletcher (11/26/2012)

---

Of course don't rebuild needlessly; check the stats and only rebuild those indexes that require it.

Also, with a reasonably well-tuned tempdb, you should strongly consider using the:

SORT_IN_TEMPDB = ON

option....

so am i.

a little more detail on what you are trying to accomplish will be very helpful here.

same concept as the total rows except instead of sum and you would use a second column variable to dynamically create column1 + column2 ... then instead of using a...

Vedran Kesegic (11/17/2012)

---

Search for "running total" on this site. In sql 2012 it is trivial with OVER() clause, but in sql 2008 or before you will have to use a...

i think this will be very help full for you. it seems like you are an accidental dba and this book is a greate guide to trouble shooting. ...

Here is some sample data so i could chew on it. i would suggest looking at DelimitedSplit8k for this, the link is in my signature or you can find...

Raastarr (11/15/2012)

---

Apologies that I keep posting but I have just amended part of the ISNULL section to DATEADD(DD,DATEDIFF(DD,0,GETDATE()),3650))

and this now allows me to extend the working pattern forwards, as I...

I would Suggest using a CTE to hold the pivot table then select your data and union it to a totals query.

This will get you close, i changed your dynamic...