Usually when people need information associated with a last instance of something, the correct method is to use a CTE that includes ROW_NUMBER with the proper partition and order and...

Thom A (10/5/2016)

---

Does this meet your needs? You'll need to change the values of the @StartDate and @EndDate Variables to suit your needs though.

DECLARE @StartDate DATE = '01-Jan-2016',

...

Thom A (10/5/2016)

---

Does this meet your needs? You'll need to change the values of the @StartDate and @EndDate Variables to suit your needs though.

DECLARE @StartDate DATE = '01-Jan-2016',

...

Why are some people with partial months included and others excluded? Is there a minimum number of days required to be counted? Or are you only counting people who...

You do realize that this thread is so old that the original article was likely written for SQL 2005, which is now deprecated. None of the scripts mention which...

A CASE statement cannot return a Boolean value. You can however return a bit or string that represents a Boolean value and test whether it returns a token that...

SvetNas (10/4/2016)

---

@drew.allen thanks for the great suggestion! Roll up definitely helps with some levels of aggregation. I don't think it could be used to pre-aggregate data for all subsets,...

I think the main issue is a confusion between logical query processing and physical query processing. The physical query processing does not need to match the logical query processing...

ScottPletcher (10/4/2016)

---

Create a proc in the master db, beginning the name with "sp_", mark that proc as a system object, then use sp_MSforeachdb to run the proc in the db(s)...

What datatype are your monthbegindate and monthenddate in that they need to be converted to VARCHAR before being converted to DATETIME?

Why are you converting monthbegindate and monthenddate to DATETIME rather...

You have to be careful with sp_MSforeachdb, because it will also run in the system databases. I assume that you don't really want to create these tables in master,...

Eric M Russell (10/4/2016)

---

So, you have this flat denormalized table containing nearly 100 million rows and 100+ columns. The problem is you need to report from it; performing rollups at...

Unfortunately distinct counts is one of the properties that is not associative, so you need to do all levels of the calculation at the same time. When creating your...

When directing answers to another forum, it really helps to post a link to that other forum.

http://www.sqlservercentral.com/Forums/Topic1823226-150-1.aspx

Drew

You don't say what you want to do when you have multiple entries for a single user in any one of the tables. The solution provided will give you...