Jeff Moden (2/1/2014)

---

sqldriver (1/30/2014)

---

Hi,

A while back I recall reading a post on here where a user needed to update a column with values until there was a new value, then...

Yep, thanks Sean. I usually end up with an ID or similar column to group by in SUM(CASE...) anyway, so it's not a total departure.

Michael Meierruth (1/31/2014)

---

OK, just saw your use of LAG which means SS20012.

But you're making completely wrong use of it.

If you delete one of the rows with cgm='5' from your data...

Michael Meierruth (1/31/2014)

---

sqldriver,

Could your data also contain a sequence like the following, i.e. cgm changes without one or more rows having cgm null in between:

('1', '2012-01-01 07:05', '5'),

('1', '2012-01-01 07:06',...

That's a fine article, but this was a forum post. There were...

I'll take that as a no :hehe:

Anyway, here's what I'm generally trying to do:

CREATE TABLE testsql (

cid integer,

ctime datetime,

cgm integer);

INSERT INTO testsql VALUES

('1', '2012-01-01 07:00', '1'),

('1', '2012-01-01 07:01', '1'),

('1', '2012-01-01...

You don't happen to be working with a Redshift dB? I am currently, and running into all sorts of nasty surprises with its feature set. :sick:

Another option might be to have PowerShell output the contents of your Excel files as .CSV files before processing. If I recall correctly, you don't need to name the 'tab'...

Thanks. Just deleted 6gb of email. I feel like I lost 20lbs.

Hi,

It apparently went well enough for them to offer me the job. I start on Monday.

I've been delving into some PG over the last few weeks, and I've found...

Yeah, I saw the limitations last night after I had a chance to mess with it. I was hoping there would be a quick way to use the sequence values...

Hi Luis,

I recently saw a PostgreSQL example where a series of dates was generated that reminded me a bit of tally table code. That's what got me curious about sequences...

Hi Jeff,

I apologize if you've addressed this elsewhere, but I was sort of curious if you'd done any testing of tally/inline tally tables vs. sequences in 2012?

http://technet.microsoft.com/en-us/library/ff878091.aspx

I'd be interested to...

I don't usually bookmark threads that aren't full of .gifs, but this is an exception.

Thanks, Jeff.

Sean Lange (12/20/2013)

---

erikd (12/20/2013)

---

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