Hello everyone!
The answers were really helpful, thank you! but i am facing a problem with language, i have strings in the format mmm-yy with months in spanish:
'ene-19' (enero...

Believe it or not, today (november 2018) I had a similar issue and solved it thanks to this post.

I've migrated an old package from a server with SQL 2000 to...

Like most of you, I use print/select to debug stored procedures. Sometimes I also use temp tables to track values.

I can be wrong, but I think the SSMS debugger is...

Good point! I've replaced the variables with another CTE.

I have also changed the code to prevent recursion by adding a Tally table so you can see the report for more...

I guess this solution works as you want.

I used a temp table with the data from your first post.

/***********************/

/* TEST DATA ...

Thanks Peter, I like the script, even when I can't see where to use it right now.

I've extended it to support up to the column index 16900 (XYZ).

/*

Original script:...

Hello everyone!

Great post!

The only way I've found to get the manager name is changing the table "_hirearchy b" for @Employees in the final select with a left join. It also...

Hello, everyone!!

I have fixed some minor details to make it work fine.

Thank you all for the script, it's really helpful.

DECLARE @TABLE_NAME sysname, @TABLE_SCHEMA sysname

SELECT @TABLE_SCHEMA='dbo'

SELECT @TABLE_NAME='Media'

SET NOCOUNT ON

DECLARE @CMD nvarchar(max)

DECLARE...