Thanks Phil & Jeff, definitely not as easy as I thought.

That link you shared Jeff is intense, I need to read and understand it more.

Is there anyway, you can think...

This mostly borrows your FROM clause except I changed DaysToAdd to be 'int' which the JSON supports (it's not in quotations).  Instead of PIVOT I always use conditional aggregation. ...

Ok, I think I'm closer, its just the final step of getting "DaysToAdd" on the same Line and making it a single entry.

DECLARE @JsonContent NVARCHAR(MAX) = 
N'{
  "Records":...

Thanks Phil & Steve, that's making life a bit easier.

So based on your code Steve, I've now changed it to the below JSON

DECLARE @JsonContent NVARCHAR(MAX) = 
N'{
  "Records":...

• This reply was modified 11 months, 2 weeks ago by  Tava.

Although there is a solution provided to the OP that works, I have to ask what the original reason is for trying to build a string based GUID base...

.

• This reply was modified 1 year ago by  Tava.

Usually, I'd agree with you on explicit vs implicit conversions. But here is...

DROP TABLE IF EXISTS #test;
CREATE TABLE #test ( ValueId varchar(30));

INSERT  #test ( ValueId )
VALUES ( '1' )
     , ( '99' )
...

The value is...

The value is actually an...

That's exactly what I was After...  I need there was an easier way than doing substring, reverse, replace etc.

duplicate post.

• This reply was modified 1 year ago by  Tava.

duplicate post.

• This reply was modified 1 year ago by  Tava.

At the moment, I've got something like this which returns me the Length of the Value I need replacing, e.g. 1 number , 2 numbers, n.... etc

DROP...

Hi All,

Sorry for the delay. I was able to get this working using the help of the above. I did use a custom string split function which I found online.

I...