If you're really on SQL 2017, why aren't you using String_Agg()?

Drew

Several months ago, someone took over development of our SSRS reports from me.  I had set up all of my reports using shared data sources.  When she took over, she...

This is a standard gaps and islands problem, but it can also be solved with LEAD()/LAG().

Drew

The confusion is...

You're missing a FETCH NEXT inside your cursor.  That being said, you'll be better off in the long run if you fix your trigger rather than trying to work around...

I wouldn't use a tally table for this problem.  It's a variation on the interval packing problem.  I believe that this works for the data given, but it might not...

Does this work for you

 ;WITH cte_test 
 
 AS ( SELECT *  
  , ROW_NUMBER() OVER (PARTITION BY clientid ORDER  BY ClientImportsId...

-- Drop target scratch table if it already exists:
IF OBJECT_ID('tempdb..#OPCantBeBothered') IS NOT NULL
DROP TABLE #OPCantBeBothered
;

-- Create scratch table:
CREATE TABLE #OPCantBeBothered
(
AccountNo INT, 
VersionNo INT, 
Amount INT, 
StatusDate...

It sounds like you want something like this:

SELECT …
FROM AccountProfile ap
WHERE EXISTS
(
SELECT AccountNumber
FROM AbsPlan a
WHERE a.AccountNumber = ap.AccountNumber
AND a.AccountStatus = 'Open'

UNION ALL

SELECT AccountNumber
FROM RitPlan r
WHERE r.AccountNumber =...

PIVOT is too restrictive for what the OP is trying to accomplish, because it only allows one aggregate function, and you need a MIN() and a MAX().

Drew

Subtract a ROW_NUMBER() from the date to get the group for consecutive dates.  I'll let you work out the details of the ROW_NUMBER() since you said you preferred clues to...

Use LAG() or LEAD().

Drew

I wpuld like to get the following columns DC, prepaid, collect, WMItem, ItemDescription on the same row by Hdrid + RID. I'm not sure if this is clear or...

I'm currently getting that message when trying to view my own profile.

Drew

I don't see anything that requires an UNPIVOT.  What are your expected results?

Are you trying to create an EAV table?  That's highly discouraged.

Drew