The second xkcd cross link of the week!

Dwain, Nevyn,

Wow Dwain that is some complex code! I have only scanned it and like Nevyn says, it requires the user to seed it with a set of predefined patterns....

No, but I think 4 hours should be OK:-)

@Nevyn

Unfortunately that is the simplified version 😀

Let's concentrate on the first part: finding records with the same repeating patterns but in different time phases.

A manual scan of the...

Michael Meierruth (12/30/2014)

---

Jeff, so what was the trick?

I guess when you need to execute something only once and it takes 900 miliseconds you give it no further thought.

Still, getting anything...

Is there any reason why you can't use the PIVOT command. You would need to include a month number and well as the month name otherwise the data will...

@KGJ

Hand-rolling your own code is a great way to learn, but have you looked at the SQL Toolbelt from Redgate. It allows you to do all that stuff to...

In the absence of the OP I will hypothesis that it is required to identify discrepancies within a warehouse.

You have 'real' warehouses and 'Transit' warehouses. Where the discrepancy between...

@jay Tee

But it's still butt ugly code 😀

It is one of the few really useful functions that is missing from T-SQL; the ability to select a MIN or...

Hi Jeff. it's a bit late in the day for me to get my head around the whole result but the technique you are looking for uses STUFF and FORXML....

my bad, that's what I get for psudoing the query

SELECT

date,

classification,

MAX(

CASE

...

Or use the ROLLUP option

SELECT

State

,ZipCode

,Count(Account) AS [Accounts]

FROM YourTable

GROUP BY State, ZipCode

WITH ROLLUP;

This will give a total for the State (record will be State, NULL,...

If you are just coming back to SQL from a long break (i.e. pre 2005) then you might want to look at Common Table Expressions as an alternative.

From my experience...

Deries (12/1/2014)

---

. We dont have any other table or column to show the off Peak or on Peak values. At present I do the, the manual calculations for onPeak...

and an address type - home, correspondence, holiday, emergency, temporary;

in fact why limit it to location addressees; it could be all addresses (email, ip)

in which case you could hold...