If anyone has any info on this, please let me know.
https://www.sqlservercentral.com/Forums/1897898/Filtered-Index-on-a-Temp-Table-in-a-Stored-Proc-can-result-in-a-Error-602

Also, today is the 32nd anniversary of the most devastating earthquake that Mexico has faced, and...

It's considered good practice and polite to share your solution...

That's easy using MIN, MAX and DATEDIFF. What have you tried?

Why would everyone read the table twice instead of just unpivoting it?

WITH myBeers AS(
  /* snippet */
  )
SELECT Person, SUM(OwedBeer) NetBeerOwed
FROM myBeers...

Using Lowell's sample data, here are 2 other options.

SELECT [create_date],
   LEFT( CONVERT( varchar(24), [create_date], 121),
      CASE WHEN [create_date] = DATEADD(dd, DATEDIFF(dd, 0,...

For this, I might keep a more straightforward approach.

SELECT LEFT( YourFieldName, CHARINDEX('[', YourFieldName + '[')-1),
   SUBSTRING( YourFieldName, CHARINDEX('[', YourFieldName + '[')+1, CHARINDEX(',', YourFieldName +...

Read the following articles about dynamically pivoting tables:
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - SQLServerCentral
Cross Tabs and Pivots, Part...

Here's a quick test. It...