Not sure why you would need this, but here is an example of how to put 3 records into comma separated values.

drop table if exists...

That's what I get for guessing 😉  You see the DDL and sample data that I provided.  That is what we need along with what you are expecting as a...

https://forums.sqlteam.com/t/sql-query-to-merge-extract-data/14668

I'm pretty sure I already responded to this in another forum, but here's what I guessed at based on what you've provided (no DDL, data, etc...)

[code...

how about posting ddl, data and expected result

as long as the data in the AuditDate column is xml, you can try this to see if it works.

drop table if exists #Audit

there's alot of things wrong with this.  First and foremost is what happens if it fails?  You will have records skipped.  Second, why?  This would probably be better as an...

I'm not sure how you would ever get inner and your data is really bad.  here's an example of what I think you want, but again only guessing here

You can execute the proc into a temp table, then use that to parse the string.

Drop procedure if exists sp_test
go

create proc sp_test...

This looks like it works, although GW's dod is incorrect in sample data

select ( SELECT count(1) N
      FROM #President p
      WHERE IsNull(p1.DiedDate,'1/1/2020')...

not sure what the issue is.  The rowcount variables should be populated once the data flow task runs

Did you look in Integration Services Catalog?

declare @t table (TRAID int, POT int, ATTID char(4), WC date, LH_MON int, LH_TUE int, LH_WED int, LH_THU int, LH_FRI int, TOTAL int...

Luis,

with over 6100 points, you've been around awhile.  You know we need DDL and data with expected results to help.