Congratulations, Jeff !!

And good job to everybody at SSC for voting the man in...

About partitioning. Look at example "H" here in BOL:

http://msdn.microsoft.com/en-us/library/ms174979.aspx

Partitions are subsets of a single table defined by a range of values. Each partition points...

Sonny, if correctly designed and coded, SQL is efficient up into millions and millions of rows. FYI, partitioning is a technique for segmenting...

I have to ask: If all of the tables have similar data, why aren't you simply using one big table?

The query would be...

The first one looks like a running total. But I can't make any sense of the other rows.

Neither (50-10 = 10) nor (20-5=5 ) compute for me.

Not being a problem, Evil Kraig. 😉

What made you decide to change your name?

Congratulations and good luck, Lynn.

Congratulations, Brandie!

If the ID is included as part of the index, the optimizer can find MAX by matching on [field_name1] and [field_name2], then reading the last value of ID. ...

Comments withdrawn. Gail's example below is a lot more clear and concise than all my verbage.

Well-written CLR has proven to have some clear performance advantages over T-SQL in performing complicated string manipulation, such as parsing of large text strings. Solutions that require array...

Where is the 'd' coming from in your output set? Is it a typo?

You could also cross apply a subquery to get the TOP (1) row sorted by date descending, or use Row_Number() ordered by date descending where row_number() = 1. ...

You're response was fine as usual, Lynn. The OP wanted the "Make MVP...

WHERE clauses evaluate expressions which return true or false values. Two simple examples:

WHERE 1 = 1 -- will return ALL rows

WHERE 1 = 0 -- will...