Viewing 15 posts - 16 through 30 (of 178 total)
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":...
December 11, 2023 at 11:02 pm
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":...
December 11, 2023 at 10:16 pm
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...
November 20, 2023 at 1:29 am
.
November 2, 2023 at 10:59 am
But its an Implicit conversion, wouldn't it be better to explicitly convert the value to Varchar.
Usually, I'd agree with you on explicit vs implicit conversions. But here is...
November 2, 2023 at 10:59 am
DROP TABLE IF EXISTS #test;
CREATE TABLE #test ( ValueId varchar(30));
INSERT #test ( ValueId )
VALUES ( '1' )
, ( '99' )
...
November 2, 2023 at 10:36 am
BUT, that will only work if LEN(ValueID) <= 12 For longer strings, you will need to break ValueId into parts to match the GUID pattern
The value is...
November 2, 2023 at 10:34 am
BUT, that will only work if LEN(ValueID) <= 12 For longer strings, you will need to break ValueId into parts to match the GUID pattern
The value is actually an...
November 2, 2023 at 10:22 am
That's exactly what I was After... I need there was an easier way than doing substring, reverse, replace etc.
November 2, 2023 at 10:06 am
duplicate post.
November 2, 2023 at 6:17 am
duplicate post.
November 2, 2023 at 6:17 am
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...
November 2, 2023 at 6:16 am
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...
October 17, 2023 at 6:49 am
I'm still struggling to adapt the articles based on the examples.
Maybe I simplified it easier on the previous example.
I've mocked up a more "realistic" data set but still cannot get...
October 11, 2023 at 10:55 am
from your use of "reverse" it seems that you wish for the elements to be returned in reverse order - why?
and if this is the case how does it...
October 11, 2023 at 9:09 am
Viewing 15 posts - 16 through 30 (of 178 total)