Forum Replies Created

Viewing 15 posts - 271 through 285 (of 1,413 total)

  • Reply To: First Two Words

    Jonathan AC Roberts wrote:

    I don't think calling complicated string_split and string_agg functions will be more efficient than calling simple string functions.

    Maybe so.  Can your chatbot make the case for it?  Splitting and...

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

    March 10, 2023 at 5:53 pm

    #4159372

  • Reply To: First Two Words

    Imo davidandrews13 has the right idea.  In SQL 2022

    select string_agg(sv.[value], ' ') within group (order by sv.ordinal) first2_in_order
    from #temp t
         cross apply (select...

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

    March 10, 2023 at 5:03 pm

    #4159361

  • Reply To: Replace function not working

    Could be a type mismatch due to the search string not being specified with the Unicode prefix N'...'

    declare @json nvarchar(max)=N'Array ( [error] => Quote not found [module]...

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

    March 9, 2023 at 7:44 pm

    #4159000

  • Reply To: Islands (no gaps) - Problem solved but could this be done better?

    Here's an alternative.  Is it better, idk

    with 
    gap_cte as (
        select *, case when UserTier<>lag(UserTier) over (partition by UserID order by StartDate) then 1...

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

    March 8, 2023 at 11:21 pm

    #4158361

  • Reply To: Use a flag, or calculate, to retrieve counts

    Imo it depends on whether or not Approved is exactly equivalent to Taken.  Could a user be officially approved and yet not take the day?  If there's an exact equivalency...

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

    March 6, 2023 at 12:59 pm

    #4157256

  • Reply To: Update row using different steptype within same order

    It could be two similar queries.  For the first one maybe you could try something like this.  It uses OUTER APPLY but LEFT JOIN would probably also work

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

    March 3, 2023 at 1:19 pm

    #4156458

  • Reply To: Query

    Jeff Moden wrote:

    Good lord. 🙁

    It's got to have you wondering, no?  Where the line is to be drawn?  How many doublings do we have remaining?  What really changes because I'm still...

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

    February 19, 2023 at 5:19 pm

    #4151660

  • Reply To: Query

    vs.satheesh wrote:

    Thank you.I am looking select statement

      Ok thank you.  Still have some questions tho

    Example 1:

    exec spLiceceQty @Productid=1,@LicenceQty= 10

    I want the following result set

    1, 2023-02-15 14:47:16.927, 25

    Why...

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

    February 19, 2023 at 4:23 pm

    #4151644

  • Reply To: Query

    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

    #4151589

  • Reply To: Query

    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

    #4151588

  • Reply To: Aggregate Select Results and convert Secs to Hours Mins.

    Jeff Moden wrote:

    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

    #4150590

  • Reply To: Sampling : Select the sample records

    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

    #4142648

  • Reply To: Case expression with NULL

    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

    #4141325

  • Reply To: JSON formatting output nested array

    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

    #4140507

  • Reply To: 60 Second Rolling Avg With Different Starting Points

    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

    #4140382

    • Viewing 15 posts - 271 through 285 (of 1,413 total)