Viewing 15 posts - 271 through 285 (of 1,396 total)
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?
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. ...
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
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...
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...
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...
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...
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
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 🙂
January 6, 2023 at 4:46 am
After looking at it again (and again) it was updated a few times
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](
...
January 6, 2023 at 2:34 am
Oops posted in the wrong spot
January 6, 2023 at 2:32 am
It not a fully asked question imo. It's a good one tho. Hopefully some of that medication was prescribed. You're looking for more efficient code. It comes down to demonstrating...
January 5, 2023 at 9:43 pm
Do you have a good example of an INSTEAD OF trigger for use with UPDATEs? I've not seen a good one yet.
It hasn't been necessary for my work so...
January 4, 2023 at 1:16 am
Except for the occasional Indexed View, this is one of the many reasons why I hate views.
Ha my exception is for VIEWS with INSTEAD OF triggers
January 4, 2023 at 12:30 am
Viewing 15 posts - 271 through 285 (of 1,396 total)