Forum Replies Created

Viewing 15 posts - 211 through 225 (of 1,419 total)

  • Reply To: Script task to get oauth 2.0 token error

    In Postman you could open the POST method and then click on the '</>' code symbol.  That should generate the cURL code of the request.  When I ask ChatGPT-4 to...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: Script task to get oauth 2.0 token error

    lazy_titan wrote:

    Sorry about that, apiEndpoint corrected, it was a typo. I am getting the same error still. 404 not found.

    Is the port number required there? Thanks.

    Try it without the "/"...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: Script task to get oauth 2.0 token error

    In the PostAsync method you're appending "/token" to the end of the HttpClient's base url which you assigned as:

    string apiEndpoint = "https://helloworld.org:443/xyz/oauth2/token";

    That would make the combined url...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: Calculating Prime Numbers With One Query

    Jonathan AC Roberts wrote:

    I took the total time (10 seconds) from the time given in SSMS application. In the messages it reports the time from statistics for the first insert and then the...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: Calculating Prime Numbers With One Query

    Can't see Jonathan's reply without a paging bump

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: Calculating Prime Numbers With One Query

    Jonathan AC Roberts wrote:

    I just improved the process a bit. You can use GENERATE_SERIES to specify the multiples of the prime that you want to delete. Also, another thing I learnt today...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: Calculating Prime Numbers With One Query

    Here's another non improvement over other methods afaik.  In theory this one seemed to hold a lot of promise imo.  When I gave it to ChatGPT to craft an explanation...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: Calculating Prime Numbers With One Query

    Jeff Moden wrote:

    @steve-2 Collins,

    Sorry... I tried your latest code on a max value of  "just" 1 million.  I stopped it at 2 hours and 8 minutes.

    Well that's disappointing.  Could it be...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: Calculating Prime Numbers With One Query

    Jeff Moden wrote:

    Ok... I'm a little gobsmacked... I ran your code with zero changes and it's riddled with syntax errors and,yet, it ran without error.

    What is the following supposed to do...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: Calculating Prime Numbers With One Query

    Jeff Moden wrote:

    The doubled-up relational symbology isn't floating my boat on an SQL Server forum, either.

    There are functions also as I'm sure you're already aware

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: Calculating Prime Numbers With One Query

    I don't know.  Setting STATISTICS ON doesn't work on Fiddle

    Simplified without the 4th CTE

    declare @max_number       int = 100;
    declare @half_max_number int...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: Calculating Prime Numbers With One Query

    As one query

    DECLARE @maxNumber INT = 1000;

    WITH BitArray AS (
    SELECT [value] AS Id, 1 AS Bit FROM generate_series(1, (@maxNumber - 1) / 2,...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: Calculating Prime Numbers With One Query

    Aha the recursive CTE has been replaced with a 3rd usage of the GENERATE_SERIES function

    https://dbfiddle.uk/bhPaKD5f

    -- Create a table to store the bit array
    CREATE TABLE BitArray (
    ...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: Calculating Prime Numbers With One Query

    More from ChatGPT-4

    Now, let me explain how the Sieve CTE works and how it fits in with the rest of the query.

    The Sieve of Eratosthenes algorithm works by iteratively marking...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: Calculating Prime Numbers With One Query

    After giving it a few tries lately I've been trying to get GPT-4 to do things which wouldn't otherwise be attempted.  So here is AI's implementation of the Sieve of...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

Viewing 15 posts - 211 through 225 (of 1,419 total)