That might be the way to go instead of using the CROSSTAB method on this one, Jonathan.

@ jay-125866 ,

Just to be sure, there are some possibly significant differences between CROSSTAB and the SELF-JOIN methods that have been offered above. The CROSSTAB method does a single pass...

@mullern,

I guess at this point, I have to ask, why does this need to be done as a Natively Compiled Proc to begin with.  The use of a Tally table...

So go ahead and do it.  Not sure specifically how a tally table is going to help here.  Besides, a tight loop should likely perform well enough on a...

Can you use a Tally function in natively compiled procs?  If not, can you build an inline Tally cte?  If so, I'd get rid of that bloody while loop.

I love it when someone posts "Readily Consumable" data along with a crystal clear example of the output that actually contains the same result data that's in the example data......

I actually didn't think of the tally table which will speed up performance, no doubt. My problem is that I need to identify all the non-printable characters and replace...

Definition of stored procedure

create procedure [dbo].[smGetMinDate] @O_dMinDate datetime = NULL
output as declare @dDefaultMinDate datetime
select @dDefaultMinDate = GETDATE()
select @dDefaultMinDate = DATEADD(mm,-(DATEPART(mm,@dDefaultMinDate))+1,@dDefaultMinDate)
select @dDefaultMinDate = DATEADD(dd,-(DATEPART(dd,@dDefaultMinDate))+1,@dDefaultMinDate)
select @dDefaultMinDate = DATEADD(yy,-(DATEPART(yy,@dDefaultMinDate))+1900,@dDefaultMinDate)
select...

@nadolguna

If it were me, I'd contact some good recruiters on this.  The good one's will know a path or two on how to do such a thing and, with a...

If it were me, I'd be disappointed in the answers on that link.  Might be...

What is it that you're ultimately trying to do?

Yeah... I can see you're looping...

What are you trying to do? Why do you like screwed up presentation formats for your data? The whole idea of client/server architecture from the 1970s is that data...

Well one...

We never intended for SQL to be used for text management. You ought to be using the proper tool to store this data. As part Lane put it in...

A few of the other folks share the same sentiment as I... why are you doing this in PoSh?  To be sure, that's a rhetorical question. 😀