Viewing 15 posts - 286 through 300 (of 1,419 total)
What determines the hierarchy of 'LicenceQty' row values from which to begin the subtraction? In the case of ProductID=1 the example appears to apply lifo, "last in, first out", and...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
February 19, 2023 at 1:21 pm
Well, what does the chatbox have to say about this one? It doesn't look too tricky imo
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
February 19, 2023 at 12:49 pm
BTW and just to clarify, I'm damned impressed with what they've been able to get ChatGPT to do. The technology behind all of that is mind boggling . My...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
February 16, 2023 at 3:59 pm
Presumably there are other employees besides Betty? If so it would be convenient to start with a table containing (unique) employees and the sample size. In the case where you're...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
January 28, 2023 at 2:30 am
The question came up based on this forum post. Not sure I'd know the answer otherwise
https://www.sqlservercentral.com/forums/topic/nullif-in-ssis#post-4122037
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
January 24, 2023 at 4:40 pm
Afaik JSON treats carriage returns as white space. At the bottom of this page it says:
Whitespace can be inserted between any pair of tokens
Then there's this...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
January 22, 2023 at 1:47 pm
Afaik this matches the output from the existing query. To add additional columns you could add additional CROSS APPLY operators and then vary the date inequalities in the WHERE clause(s) Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
January 21, 2023 at 6:49 pm
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
Viewing 15 posts - 286 through 300 (of 1,419 total)