Unless I'm reading it wrong, sounds like you could use Service Broker for that...

"Here are some examples of reasons you might use Service Broker:

Asynchronous triggers. You can construct asynchronous triggers either...

Created a User DSN, and it worked a champ.

Then for fun I created a trivial stored procedure just to see if I could call it.

CREATE SCHEMA junk;

CREATE...

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

something like this?

SELECT DISTINCT ID
FROM Response r
WHERE EXISTS (SELECT 1 FROM Response r2 WHERE r2.ID = r.ID AND r2.result = 'Y')
AND EXISTS (SELECT 1 FROM Response r2...

=IIf(Round(Fields!Qty1.Value,3) = Round(Fields!Qty2.Value,3),"Red","Black")

This almost worked <g>.

DECLARE @tableName NVARCHAR(50);
DECLARE @TemplateSQL NVARCHAR(500)=
'SELECT *
INTO #tempData
FROM dbo.MikeyData n
EXCEPT
SELECT *
FROM #tempData d;';

DECLARE @InsertSQL NVARCHAR(500);

DECLARE tables_cursor CURSOR  FAST_FORWARD
    FOR 
SELECT ao.name
FROM...

What are your options?

If you can use SSRS, it's stupid easy.

Can you use a matrix in .NET? (Well, SSRS is an ASP.net application, so I would think so.)

I created a table for this... (Far easier to do in SSRS with a matrix visual)

now someone who's better at Pivot than I am can have a play.

            
September 1, 2020 at 2:26 pm
            
#3785215

            
            
                                                
        

Got some sample records?  And how about a couple of CREATE TABLE scripts. Or do you have something against tested queries?

So what's your question? You want to split the last and first names into separate columns in your SQL query? (I would do that... makes querying much easier and faster).

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, 6 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...