CirquedeSQLeil (12/14/2010)

---

Stefan Krzywicki (12/14/2010)

---

GilaMonster (12/14/2010)

---

Thunderstorms here, but no snow storms. (I'd worry if there were)

Want some entertainment? I give you Gus's reply here http://www.sqlservercentral.com/Forums/FindPost1034345.aspx, nominated for comment on the week.

It...

I can see why. @=) I'll second that...

*chirp*

*chirp*

I dare say I can hear the crickets.

Did the snowstorms really affect that much of our membership?

Or is it just the natural death of this thread I hear looming?

I saw that on the Weather Channel this morning. I'm surprised the entire roof didn't hit the field.

Wow. I just had the worst time trying to post to Grant's blog. Three times I had to try before my post went through.

You'd think he was throwing a contest...

Change of subject. Someone posted an interesting link on Twitter last week that I retweeted. It's about Wikileaks from a security standpoint. I thought you might find the blog interesting.

http://www.schneier.com/blog/archives/2010/12/wikileaks_1.html

And...

So.... You're advocating that I use SSIS to create the table first?

petervdkerk (12/12/2010)

---

I want the statement to be flexible and if I later add columns to the database, I dont want to have to alter the query to include the newly...

LutzM (12/10/2010)

---

Unlikely. The tree is already occupied and I can't...

Have you registered the .dll as I first suggested?

Do you know what parameter the error message is referring to?

EDIT: This is an old thread, but it might be able to help you. http://www.bigresource.com/Tracker/Track-ms_sql-0kT9qz2f/%5B/url%5D

Ray K (12/10/2010)

---

crookj (12/10/2010)

---

Thanks...

Yeah, but...

LutzM (12/10/2010)

---

You get a table scan because your subquery has no limiting WHERE condition. In order to find max(Effective) per CoverageKey you'd need to scan the entire table (or clustered...

Horses don't feed themselves.

@=)