Nuts. The query I had did it pretty quick with about 40 columns and 200k rows. For some reason I felt silly writing OR 40-ish times, but not enclosing 40-ish...

Just kind of eyeballed this because I just used similar syntax to find the max value across multiple columns for something else.

SELECT TOP(1) TimeStamp,

(SELECT MIN(g)

...

Yessir. Spacklesville. Population: me.

Maybe I'll take up whittling.

That was the link in my Spacklesville comment in my first post 🙂

Hi Dwain,

In my tinkering with it, it certainly seemed like the error messages I'd get would match where the print statements stopped printing.

So, if the error was something like...

I use this many times a day to filter out duplicate data. It was recently tweaked to update the CTE directly after a reading a post by Luis C. on...

I finally got some time to work on this, and wrote a couple dynamic Pivots that get me partially where I need to be. They need a little work, mainly...

Howdy,

As promised, here's the queries you wrote against full data. I decided to add the index suggested by the query plan for the query with a pivot. It ended up...

Can you use sqlcmd? This article was recently in my RSS feed.

SQL SERVER – Export Data AS CSV from Database Using SQLCMD[/url]

I'm going to keep both of your solutions on hand and keep testing as more data gets added. I'm also interested to see if pivot holds up. I'll post back...

I suppose it's also partially because I've never successfully written a pivot query without cursing and writing it another way. 😛

Also, I could make an index here, but these staging...

Ask and ye shall receive.

The first query plan is...

That's sort of what I figured. Thanks again Lynn.

Is it generally better to keep filters out of CTEs? Since your suggestion to move it, I've tried it in some other queries I've written and the query plans no...

Hi Lynn,

They're all 1 in the test data, but not in my table:

statusflagDescription Counts

1 ...