Heh... where's "Clippy" when you need him?  I can just see him saying "It looks like your trying to design a table to hold CDRs (Call Detail Records).  Do you...

Then after you wrote this I thought I'd see what ChatGPT could do to create a table with the data:

So I pasted the table in the question...

Then after you wrote this I thought I'd see what ChatGPT could do to create a table with the data:

So I pasted the table in the question into ChatGPT...

Unless the "with the matching dates" is to be interpreted as a date range selection, in which case Jeff Moden's integer math would be needed to ensure that the...

@Wecks ,

We still need an answer to my questions about the required rounding. Thanks.

EDIT:  Never mind... forgot to refresh before posting this.

@Wecks ...

Since these are CDRs, do you need to obey such rules as the classic "Whole minute rounding (up) per call" rule or any other some-such rules?  Either way, which...

Create some test data:

DROP TABLE IF EXISTS #temp
GO
SELECT *
INTO #temp
FROM (VALUES 
(001, CONVERT(DATE,'2023-02-23'), '123', 'a@a.com', '10:23:00.000', 500, 'W'),
(002, '2023-02-23', '246', 'b@b.com', '09:36:00.000', 456, 'W'),
(003, '2023-02-22', '123',...

Unless I'm missing something in the requirements, "awesome SQL" isn't required here... just a GROUP by on the columns you mention, a COUNT(), and a SUM() of the CallDuration column. ...

No.  I don't avoid it.  I never write things that way but I don't change them if I come across them.  As you say, it doesn't cause any issues except...

The only time I've seen one like that is when someone use the "Query Builder" functionality and only in what I refer to as a "Skip Join" where Table A...

ARPRINCE,

Have you looked at the query plans for the two queries?  The LEFT JOIN method is doing a full table scan per join.  That could be a (big)...

Be careful of "old" tutorials on this one.  They HAVE changed it, especially starting in 2019 (according to the MS documentation) and some of the "old" methods may no longer...

Interesting... the first time I clicked on it, it took me to a page selling hair-care products with that picture on it.  I just clicked on it again and, you're...

I'm thinking that may have been their goal...

If you've been running without partitions for 12 years or so, why add them back? Partitions are all about data management, not performance. If you're not dealing with all...