Which method of running total is the report currently using?

Have you considered using SUM() OVER()?

Whichever method you're using, indexing will profoundly affect the query velocity.

OK, so I'm curious and interested in expanding my repertoire when it comes to liquor...

Whiskey / whisky vs scotch, and, what's so bad about Jack D?

(Note, I've only recently...

Thank you so much for...

please don't start this - as much as I love food, i'm sick of it at the minute - i'm forced to eat nearly 5000...

Did someone mention food?

Sure

GROUP BY City ORDER BY COUNT(*)

SELECT city, 
       COUNT(*) 
FROM gcdf_DB..PeopleContactInfo
GROUP BY City

SELECT city, 
       COUNT(DISTINCT PeopleID) 
FROM gcdf_DB..PeopleContactInfo
GROUP BY...

If some conditions are met...

https://sqlperformance.com/2018/02/sql-plan/setting-and-identifying-row-goals

Please post an actual (as opposed to estimated) execution plan as a .plan attachment. You can use your plan interpreter to mask real table names if necessary. Do this after...

SELECT 
get_customeVal_3 = ISNULL(SUM(CASE WHEN year_num = @year1 AND chart_code = '3' THEN close_amt ELSE 0 END),0)
- ISNULL(SUM(CASE WHEN year_num = @year1 AND chart_code = '36101' THEN...

Hello,  below is the data before filtering out, if you see A-06/11/2019 9:15  between A-06/11/2019 9:10 and A-06/11/2019 9:25, that's why it is not showing in end result. It...

;WITH MyTable AS
(
SELECT * FROM (VALUES
('A', '06/11/2019 09:00', '06/11/2019 09:15'),
('A', '06/11/2019 09:05', '06/11/2019 09:20'),
('A', '06/11/2019 09:10', '06/11/2019 09:25'),
('A', '06/11/2019 09:15', '06/11/2019 09:30'),

('B', '06/11/2019 09:05', '06/11/2019 09:20'),
('B', '06/11/2019...

• This reply was modified 5 years, 1 month ago by  ChrisM@Work.

Good catch Jonathan, thanks.

https://blogs.msdn.microsoft.com/samlester/2013/09/23/eomonth-equivalent-in-sql-server-2008-r2-and-below/

-- Avoid DISTINCT, it almost always invokes a SORT.

-- Avoid reading tables more times than is necessary

SELECT -- DISTINCT

H.Customs_Entry_Num as [Entry Num]

,H.Entry_Summary_Date

,L.Part_Num

,L.HTS_Num

,l.HTS_Value

,L.Line_Item_Duty AS Duty

,z.HTS_NUMBER

,z. PTNR_ID

,z.ELIGIBILITY

,z.Created_Date

,z.COMPOSITE_PART

FROM ADHOC.ATS_ESH H

INNER JOIN adhoc.ATS_ESL L

ON...

SELECT

[LastDayOfThisMonth] = EOMONTH(GETDATE()),

[SecondLastDayOfThisMonth] = DATEADD(DAY,-1,EOMONTH(GETDATE()))