Could you explain the logic behind how your desired ranking  works?

I rewrote your create table and inserts, because they didn't run. You don't need DateTime2 if you're not using time.

CREATE TABLE [test2]
(
[InDate] [date] NULL,
[OutDate] [date] NULL,
[weight] [float]...

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

Not for me. Can you show at least a partial expected result from the query using the data you provided?

This worked:

SELECT t.*
, ca.value
FROM #tblTest t
CROSS APPLY STRING_SPLIT(t.FileData, ';') ca
WHERE LEN(TRIM(ca.Value))>0;

Use ISBLANK([ColumnWithNulls],"AlternativeValue")

ISBLANK is analogous to T-SQL ISNULL()

Is there a really short article showing how to do this from Python outside of SQL Server? (Or from Jupyter Notebooks?)

Then you can use pandas to do the data analysis...

FILTER(<tableObject>, ISNONBLANK([Column]) )?

(Maybe it made sense to me because I used to work on "databases" where nobody understood normalization... except my databases were small (in terms of records)... there were stupid wide...

That's what I assumed it meant. Other interpretations didn't make sense. I suppose writing the table name and column name to at least a temporary table and then using that...

I kinda hope there's a better way of doing this... but this works to create a SQL statement containing only the columns with data (in any of the rows)...

            
August 25, 2020 at 6:03 am
            
#3783170

            
            
                                                
        

Fill in the missing dates in what table? In the shift table?

This should get you started:

SELECT c.DateKey
FROM dimCalendar c
WHERE NOT EXISTS (SELECT 1
    ...

This is somewhat cringeworthy, but since nobody else answered...

use tempdb;
go

-- create a table to store the results:
CREATE TABLE GotData(
RecNo INT IDENTITY,
col1 char(1),
col2 char(1),
col3 char(1),
col4 char(1),
col5 char(1),
col6 char(1)
);
GO
--...

You've been here for a while...

Surely you know how to post consumable data.

When I copied and pasted your pictures into SSMS, it wouldn't execute them... so I don't know how...

Something like this maybe?

SELECT *
FROM
(SELECT MasterRolls
, MrWgt
, TrimWgt
, rn = ROW_NUMBER() OVER (PARTITION BY MrWgt ORDER BY TrimWgt)
FROM RollSlice) orderedSlice
WHERE orderedSlice.rn = 1;

Jeff explains how to post consumable data in this article. Absolutely worth reading. If you read it, and follow the instructions in your next post, someone can write a...