A covering index could certainly help... but there's a lot of things that will change an Index Seek into and Index Scan... usually non-sargeable WHERE clauses and ON clauses. ...

Then, it should be a single table. If you make it an "adjacency" (parent/child) model, you may be ok depending on how you're going to drill down and how...

Not only is it a "doosie", but it's darned near a duplicate...

http://www.sqlservercentral.com/Forums/Topic435994-361-1.aspx

Which "above script"... don't waste time, be specific, please.

You also said you wanted to update the table with address info... heh... what if a person has 2 addresses?

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.