If you can create a stored procedure that returns the data that you need, then you can use that as the source of your report/table in your model.

Just in case...

Two things:

1. this is a SQL Server forum, not a Python one.
2. this thread is over 10 years old.

One way is to insert the result of the stored procedure into a temporary table, and then join that table to your other table in a query.

/*...

What was the solution? Can you post it?

without some tables it's impossible to diagnose or help.

Sounds like a job for ROW_NUMBER() but it's hard to say for sure.

just playing the contrarian...

one thing to keep in mind if you do ever have to validate any of the address stuff, it would be easier if it were broken up,...

I think it was Brandie Tarvin that wrote about this? TBH, I can't remember anymore.... Someone on here used to break SQL Server one setting at a time and writing...

Sorry, wrong function. you want STContains.

Remarks

STContains() always returns null if the spatial reference IDs (SRIDs) of the geometry instances do not match.

Examples

The following example uses STContains() to test two geometry instances to see if the first instance...

You use the (longitude, latitude) to create/define a @Point. and then you use STDistance to calculate the distance between them.

STDistance (geography Data Type) - SQL Server | Microsoft Learn

Day late probably, but one thing to remember is that

<Aggregate> OVER (PARTITION BY <columnName>)

is the windowing version of

<Aggregate> FROM... GROUP BY <columnName>

and windowing functions do not reduce the number of...

Something like this?

SELECT  c.CustomerID, MAX(c.CallDate), STRING_AGG(c.Notes,' | ')
FROM (VALUES
(433,    '2018-11-06 11:08:12.793',  'Customer called'),
(433,     '2018-11-06 11:08:12.793',  'Customer left...

Dave,

Got some more data? Enough to weed out the false positives etc?

Like this?

SELECT c.CustomerID, c.CallDate, STRING_AGG(c.Notes,'|')
FROM (VALUES
(433,    '2018-11-06 11:08:12.793',  'Customer called'),
(433,     '2018-11-06 11:08:12.793',  'Customer left message')
) c(CustomerID, CallDate, Notes)
GROUP...

My code basically looks for the Causality or Relatedness columns and then counts back from there. That was the only sensible way of doing it. The weird 1/3 or whatever......

just wondering. There's not really a way to achieve this without dynamic SQL, right? I don't think so because you don't know beforehand how many of the repeating groups there...