Heh... another keen observation is that you still haven't told us how things worked out. 😉

Crud... I just glanced at the formulas... didn't see that they were subtracting 1 second.

Also, didn't know which artical you were referring to... it doesn't show in the post.

Thanks for...

I have to admit, I'm confused as to why the question was even asked... the OP had a "Last day of the Month" formula... surely it's an easy deduction to...

1) Is the design I've built the "right" way to go (see condensed design below)?

2) How do I PIVOT twice?

3) There are roughly 20 tables with strict PK to FK...

I need to break these 10 tables into 50 tables 1 for each state ... Each state will have its own table... What is the best way to do...

Heh... says a lot about whether thee and me are normal, huh?

Merry Christmas, Gail.

What's going on is that you're updating the same columns used in the join... that's almost never a good thing because it will frequently cause the join to "reform" after...

Apparently not... I've still not seen the correct answer from Karthik.

Karthik,

This is what I spoke of on one of the other posts... it's also why people get so angry with you. You banter the "Senior Software Engineer" label all...

Grant is spot on... If you want to avoid RBAR, stop thinking RBAR. The key or "secret" to that is to never ever think about what you want to...

Now, that's quite an article... some great references, too! Thanks for the research, Steve.

Yes, there is a "secret"... simply think about what you want to do to columns instead of what you want to do to rows. That and having a little...

Now, thats a "hint" if I ever saw one... 😉

Heh... another compliment. Thanks, Jason, but...

Shoot... once I learned it, I was just aching for a place to use it! ...