Well, yes, I've worked at it from that angle, too. However, your query is only picking up the 'EN' dates, not the ones that are begin dates by virtue...

Well, ***!*** What I'm trying to do is dynamically generate a list of columns for a pivot. The columnnames, of course, are actually values. So they change...

I, too, will have a need to do this. I don't have a direction to point you in, but I assume you would create a .NET assembly and put...

Yeah, I think that's what I was looking for. I can extrapolate MAX(CASE WHEN [field] IS NOT NULL THEN [date] END) to do what I need.

Thanks for the guidance

Jeff,

That looks pretty good, but I was just working with a reduced dataset as an example. I need to expand it to use groups of IDs. I need...

Excellent! Thank you. It looks like I was on the right track. I had the row_count() in there, but I was trying to use < rather than...

Ok. I coulda sworn I've put cross applies in other sps. It seems like the best way to go. I'm trying to generate a denormalized column result...

This version uses temp tables instead of a table var (that's still there if you search/replace). In case you're wondering, I took out the code that does an audit...

Oh, and in case anyone is curious, the reason I'm running it as an sp and not a query is because I need to return two resultsets, and I can't...

@ninja: yes, of course, those are all issues. However, the argument goes: it's a development database - little or no load, and I can run first the...

Well, that's a possibility, but I tried executing the stored proc 'WITH RECOMPILE', and it's no faster. In other words, compensating for the execution plan not being optimized didn't...

Argh! Stops just short of being useful!

match rows. I mean, I suppose I *can*, but it means joining back on like four or five columns to be unique.

No - how much change does that setting make?

I'm trying to get the update to go through, see if that helps.

That's useful information: WHERE -> GROUP -> SELECT -> ORDER

Yeah, the CTE is probably the way to go. It's a new tool; I'm not used to thinking about it.

Thanks...