Viewing 15 posts - 1 through 15 (of 1,419 total)
This is the same system from 5 years ago with some additions. Are you looking for...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
September 2, 2026 at 11:36 am
I'm aware that older versions of the optimizer had a issue where they were filtering some data after logic that was causing queries to fail, but I haven't see...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 23, 2026 at 9:10 pm
another worthless image that can't be fully read. put plain text next time please.
Yeah 4 worthless answers in one topic. 3 of them are basically unrelated to the question...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 23, 2026 at 4:58 pm
I'm trying to add a filter in my WHERE clause that basically says "omit records if [BillingReason] in (1, 2, 3) AND ([NewInsID] IS NOT NULL AND [OldInsID] IS...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 21, 2026 at 10:27 pm
Hey there, got answers to Jeff's questions?
"what if I wanted to get a list of everybody in a "tree" that reports to a given employee?" and "how do I determine all...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 13, 2026 at 3:48 pm
Incorrect again and in the same way. TRANSLATE was introduced in 2017. The code is not being run against the runtime it's suggested to be for. Again local plausibility is...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
June 29, 2026 at 2:27 pm
What're we looking at here? The t-sql is using STRING_AGG and STRING_SPLIT which were not available in SQL Server 2008. Imo this is really a 2 part question which is...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
June 28, 2026 at 9:02 pm
In SQL Server 2022 they added a bunch of features which theoretically could be employed, like PSP "Parameter Sensitive Plan" optimization which stores more than 1 plan for a proc. ...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
June 13, 2026 at 2:09 pm
Short answer: the F5 button.
Back in the day, like the 90's, I worked for a music "record label" where the talent reps could send an email to request@datalab.xyx (not the...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
June 10, 2026 at 4:22 pm
A GUI sems like a good approach until you have to build one lol. What about a stored procedure to generate the scripts? Step 1: tokenize the parameters in the...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
June 8, 2026 at 3:35 pm
Ha, ok that's a nice inversion of the problem. Nicely done. Posting code in a forum is an invitation for nitpicking of course. One assumption baked into the query is...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
May 26, 2026 at 4:29 pm
DECLARE @MissingNumbers TABLE (N INT primary key not null);
INSERT @MissingNumbers(N)
VALUES (1),(2),(4),(5),(7),(8),(11),(12),(13),(15),(17),(19),(20),(102);
--Steve's query (based on Paul White's query, which is based on Jeff Moden's query)
SELECT GapStart = Lo.LoN,
...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
May 26, 2026 at 1:13 pm
The original post: "I have the data like 1,2,4,5,7,8,11,12,13,15,17,19,20. How to find the missing numbers in the series?"
If the data is like, or similar, to the series provided as an...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
May 26, 2026 at 2:24 am
hi hope this helps
Fwiw, this is the 2K8 forum. LEAD and STRING_SPLIT were not available. Also, where is 10? It's skipped in the list of missing. The column labeled...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
May 24, 2026 at 7:17 pm
Jeff's question is really an open issue. As written the requirement isn't clear so what does "not working" mean? The predicate should already exclude values with two or more dots: Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
May 21, 2026 at 1:14 pm
Viewing 15 posts - 1 through 15 (of 1,419 total)