Viewing 15 posts - 286 through 300 (of 1,413 total)
It seems tricky to wade in on this because maybe it's ok the way you're doing it. Or idk maybe more than one thing is amiss. Why add columns in...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
January 17, 2023 at 4:59 pm
Well the flip side of that question is, if you're passing the information on to a system that wants to read JSON do you store the sqlified data in...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
January 13, 2023 at 11:02 pm
but do you suppose that they'll actually use your good code to "normalize the data" and store that normalized data in a database or store the JSON and parse...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
January 13, 2023 at 8:03 pm
What could you say about the relationship between the cranes and the fixed locations? The distances being calculated are between the cranes and the fixed locations? Can cranes switch locations?
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
January 13, 2023 at 5:05 pm
You just wrote custom code on the database side of the house by including INT and NVARCHAR(MAX) in the code, no? 😛
Of course, the differentiated database code is custom. ...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
January 13, 2023 at 3:59 pm
And there's nothing wrong with ratbak's approach. It could be an efficient way. The downside is having to do double REPLACE of the array brackets
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
January 13, 2023 at 3:13 am
TBH, I have an extreme dislike for all of the solutions on this thread, not because of how they were coded, but because such code was required to begin...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
January 13, 2023 at 3:00 am
Sorry I haven't gotten back to you but I had a lot of hospital and doctor appointments lately, so much, I haven't even had a chance to place any bets...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
January 12, 2023 at 2:09 am
It's valid JSON. You could try either with two OPENJSON's or one OPENJSON and 2 JSON functions
/* two OPENJSON's */
select SerialNumber, ojc.[value] as ChannelID
from openjson(@json) with (SerialNumber...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
January 11, 2023 at 6:38 pm
I cannot remember if you are the person who set this site up or not, I know he was called Steve, just forgot his surname.
That's Steve Jones. He's the...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
January 6, 2023 at 3:39 pm
As per Phil needs data. Hmm... either the rows would need to be expanded or dynamic sql? In order to use ROWS BETWEEN N PRECEDING we're stuck with N being Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
January 6, 2023 at 1:41 pm
Sorry I shouldn't have wrote that. I love horses and racing too. Yes, it passes my visual test now 🙂
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
January 6, 2023 at 4:46 am
After looking at it again (and again) it was updated a few times
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
January 6, 2023 at 2:53 am
Anyway code could be inferred from what's there. I don't want to know about horse racing. Untested you could try
drop FUNCTION [dbo].[udf_GET_EACHWAY_RETURN_itvf];
go
create or ALTER FUNCTION [dbo].[udf_GET_EACHWAY_RETURN_itvf](
...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
January 6, 2023 at 2:34 am
Oops posted in the wrong spot
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
January 6, 2023 at 2:32 am
Viewing 15 posts - 286 through 300 (of 1,413 total)