Oh, so are you doing that through SSIS?

NineIron,
Are you doing the summary for this stuff in Access or where? I'm only asking because doing this in SSRS is stupid easy (use a Matrix)
Pieter

I don't think I have ever gotten SSRS completely configured properly before, so I'll take it!
Gotta celebrate the victories when you get them!

The Report Builder stuff totally...

I've gotten Report Builder to work, so I'm getting somewhere. When I'm more alert, I'll see if I can get SSRS properly configured. (After watching several videos on it)....

Great, I'll check it out...
Because I let the installer configure everything, and of course the portal doesn't work right. (I can see it, but can't publish.)

Are the recommendations/steps for configuring SSRS the same since 2008? I've seen videos on it on youtube and I could probably do that (have a 2012 book too...) It's just...

Sue,
Got annoyed and uninstalled and reinstalled it. Maybe I need to learn to read the logs. Which should I look at? (Where is it?) Right now I can connect...

Unless you can group your data somehow, I don't think so. What you're describing is Excel, not SSRS.

Could you post a CREATE TABLE script and an INSERT script to populate it?
I think you can use Jeff Moden's DelimitedSplit8K function to break the individual attributes...

I think this is close... back up your table or wrap this in a transaction and roll it back when testing.. The INTERSECT returns the DuplicatingValue where there is at...

Could you post the CREATE TABLE script for the expected result?
It seems that you could do this using a combination of the windowing function LAG() and STUFF() to concatenate...

DelimitedSplit8K is your friend.

Happy reading. Happy learning.

Something like this:
CREATE TABLE Insurance (
    RecordNo INT IDENTITY,
    PolicyNo INT NOT NULL);
GO

INSERT INTO Insurance (PolicyNo)
VALUES (34564),(67548),(34564),(98271),(90198),(98271);

CTE to identify and delete...

Oh, FFS, Got Google?
https://www.databasejournal.com/features/mssql/managing-sql-server-services-with-powershell.html
should give you a pretty good idea.

Then use OUTER APPLY instead of CROSS APPLY.