Forum Replies Created

Viewing 15 posts - 76 through 90 (of 1,419 total)

  • Reply To: Closest to ProcDate

    Alternately

    with rn_cte as (
        select pv.PatID, pv.AcctID, pv.ProcDate, 
               iif(v.abs_diff>=2, null, dv.Department) Department, 
    ...

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

    November 7, 2024 at 2:50 am

    #4478277

  • Reply To: Find rows with very close time stamps

    If any consecutive click within 2 seconds is sufficient then the query posted looks ok 🙂

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

    November 1, 2024 at 11:35 am

    #4476390

  • Reply To: Find rows with very close time stamps

    daytonbrown2 wrote:

    Given the following table and query, this will return any records(based on message_id) that have timestamps within 2 seconds.  This works and gives me the correct output.

    The query...

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

    November 1, 2024 at 11:11 am

    #4476368

  • Reply To: strange selection for update

    Instead of typing up an example I pasted your code next to a table from another topic and then did cut/paste/replace the column names.  "...ts.PKey is not column of subquery"...

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

    October 30, 2024 at 6:03 pm

    #4475539

  • Reply To: strange selection for update

    joerg.kannengiesser wrote:

    your are right: using a qualifier results in an error (unknown column):

    update TempSel set WertA = 'TEST' where PKey in 
    (select Q1.PKey from (select PKey as...

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

    October 30, 2024 at 3:14 pm

    #4475462

  • Reply To: From each string, extract numbers following a '#' and create separate row

    Or what's the question?  It seems the topic's scope has crept after solutions were posted

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

    October 25, 2024 at 7:47 pm

    #4473825

  • Reply To: From each string extract Numbers following a '#' and create separate row

    SqlRookie wrote:

    ... extract all numbers which follow a '#' and then create a new row for each. 

    So far I'm not seeing a solution for which each character returned is an...

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

    October 23, 2024 at 9:12 pm

    #4472920

  • Reply To: ETL data load DML SP slowness suggestion

    "This table does not have any index and tigers. It has only PK."

    The FROM and WHERE clauses of the INSERT:

    FROM [DLSTYTOTAL] STG Left Join [TOTAL_RAW] TGT ...

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

    October 7, 2024 at 1:52 pm

    #4466037

  • Reply To: Help with unique constraint

    Ant-Green wrote:

    You'll need some app / query logic to prevent it.

    Or a TRIGGER.  This is the sort of situation where one could be appropriate imo

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

    October 2, 2024 at 8:23 pm

    #4464699

  • Reply To: Check sequential order of status of items

    Yeah, it's not clear.  The next sentence implies only 102 needs to be "printed" out.  I'm picturing one of those giant dot matrix line printers that used to fill up...

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

    September 29, 2024 at 7:44 pm

    #4463577

  • Reply To: Check sequential order of status of items

    Hmmm... Phil's query returns 1 row (Rownr=7) for ItemId=102.  The topic says: "If the status is not in this order for any item then we need to print such items." ...

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

    September 29, 2024 at 3:36 pm

    #4463548

  • Reply To: Dead to Me

    It's as popular as ever but I've always found JavaScript difficult to work with.  With JavaScript it's like you're inventing everything whereas with SQL and other languages it seems more...

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

    September 27, 2024 at 6:12 pm

    #4463176

  • Reply To: Query to return all data that has same site, section and date

    If the ID is unique then yes DISTINCT would do nothing.  I was sort of thinking right-to-left if there were duplicate properties there could also be duplicate ID's.  No data...

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

    September 25, 2024 at 7:58 pm

    #4462419

  • Reply To: Query to return all data that has same site, section and date

    My guess is to copy Drew's query but with DISTINCT in the outer SELECT

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

    September 25, 2024 at 3:11 pm

    #4462333

  • Reply To: Solving FIFO Queues Using Windowed Functions

    ????

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

    September 24, 2024 at 6:14 pm

    #4461960

Viewing 15 posts - 76 through 90 (of 1,419 total)