Post the CREATE TABLE scripts and someone can help you. =)

Great! Could you post the solution you came up with?

I'm no expert, but you have to unravel SQL  from the innermost queries to the outermost.

is there a shortcut? Not that I know of.  I'd love to be proven wrong,...

Your data is a bit wonky, but maybe something along these lines?

SELECT meshtype,

[datetime] as stamp,

tonsProduced,

theDate = CAST([datetime] AS DATE),

theTime = CAST([datetime] AS TIME)

-- fv = first_value([datetime]) OVER (PARTITION BY meshtype...

Normalization 101 time, I think. that's a LOT of repeating fields (any time I see a column name with a number at the end, I'm immediately suspect).

Is this supposed to...

• This reply was modified 4 years, 2 months ago by pietlinden.
• This reply was modified 4 years, 2 months ago by pietlinden.

This looks like it's supposed to be looking for the @current_proc_name value, not the literal string 'SOURCE', but then WTH do I know?

AND CHARINDEX('ALTER', @proc_source) < CHARINDEX('SOURCE',...

So what do you do then? Use XE to determine which queries are run and how often to determine whether the workload improves or not with the new indexing?

Create a unique index on all the columns and make that unique?

Multiply the result of your sum by 1.000 (adjust the number of zeroes as needed), and it will be converted to a decimal.

use datediff and calc full days first, then subtract, then repeat for hours, and then minutes?

FWIW, here's the worked solution, so folks at home can play along...

use tempdb;
go

/* setup script */CREATE TABLE LineItem(
LineNum int not null,
ItemNo char not null,
Qty tinyint not null);
GO

INSERT...

• This reply was modified 4 years, 3 months ago by pietlinden.

right-click on the table, and "script table as"... then "Create to..."?

SELECT ...

FROM query1

UNION ALL

SELECT...

FROM query2

If they're dates, use something like >= @StartDate AND < @EndDate.

No need to do all that expensive conversion.

use a windowing function with SUM and UNBOUNDED PRECEDING.