Forum Replies Created

Viewing 15 posts - 166 through 180 (of 380 total)

  • RE: Windowing function puzzle

    Mark Cowne - Friday, March 3, 2017 8:49 AM

    Can you post some sample data.

    This appears to work

    DECLARE @mytable TABLE(ColumnA INT, ColumnB CHAR(1))
    INSERT...

    March 3, 2017 at 10:08 am

    #1931572

  • RE: Windowing function puzzle

    Jeff Atherton - Friday, March 3, 2017 7:12 AM

    Window functions are only allowed in the SELECT and ORDER BY clause. So if...

    March 3, 2017 at 8:36 am

    #1931527

  • RE: Windowing function puzzle

    Mark Cowne - Friday, March 3, 2017 7:03 AM

    You can use


    DENSE_RANK() OVER(PARTITION BY ColumnA ORDER BY ColumnB) +
    DENSE_RANK() OVER(PARTITION BY ColumnA ORDER...

    March 3, 2017 at 8:33 am

    #1931526

  • RE: Windowing function puzzle

    Actually, let me clarify it a bit more and simplify the situation more succinctly:

    March 3, 2017 at 5:45 am

    #1931467

  • RE: Windowing function puzzle

    sgmunson - Thursday, March 2, 2017 8:32 PM

    Why not use a windowed version of COUNT?

    SELECT a.*
    FROM dbo.ComplexQuery AS a
    WHERE COUNT(DISTINCT ColumnD) OVER(PARTITION...

    March 3, 2017 at 5:28 am

    #1931464

  • RE: Windowing function puzzle

    Eddie Wuerch - Thursday, March 2, 2017 8:27 PM

    You've basically hand-coded a DENSE_RANK() ... WHERE MAX(<DENSE_RANK() value>) = 2. The sample data...

    March 3, 2017 at 5:27 am

    #1931462

  • RE: The Multilingual Programmer

    While I've most likely forgotten a number of them, these are the ones that stick out in my mind most readily:

    BASIC (DEC...

    February 24, 2017 at 6:53 am

    #1930150

  • RE: Query Performance Tuning – A Methodical Approach

    GilaMonster - Friday, February 10, 2017 2:13 PM

    No. those two queries are completely identical in results and performance.

    If, however,...

    February 10, 2017 at 3:16 pm

    #1927900

  • RE: Query Performance Tuning – A Methodical Approach

    Since Steve was kind enough to re-post this in today's daily email, I just now was able to read this posting.  Nice job Gail!

    While the purpose of the...

    February 10, 2017 at 1:28 pm

    #1927884

  • RE: GetDate() in blocked sessions

    Blech! I knew the right answer but clicked the wrong option. Goes to prove that jumping too quickly to answer without double-checking can be hazardous!

    January 4, 2017 at 5:40 am

    #1920578

  • RE: Import data in parquet format

    The team did identify a method of pushing the data to SQL Server but this approach requires coordinating the stored procedure execution on SQL Server to occur AFTER the data...

    December 5, 2016 at 9:31 am

    #1916031

  • RE: Import data in parquet format

    That's the thing I like about you Jeff. You're always full of optimism and hope! 😛

    However, I've not given up hope yet. Who know, since support for XML...

    December 5, 2016 at 9:17 am

    #1916024

  • RE: Complex foreign key

    Carlo Romagnano (9/22/2016)

    Aaron N. Cutshall (9/22/2016)

    I got the responses correct except that I also included "Command(s) completed successfully." -- which does flash briefly due to the master table creating successfully...

    September 22, 2016 at 7:59 am

    #1902472

  • RE: Complex foreign key

    I got the responses correct except that I also included "Command(s) completed successfully." -- which does flash briefly due to the master table creating successfully (doing them individually shows that...

    September 22, 2016 at 6:56 am

    #1902449

  • RE: VALUES limit

    BrainDonor (9/16/2016)

    They are defaults within Tools/Options/SQL Server Object Explorer/Commands (in SSMS 2014 - may be elsewhere in other versions) and therefore configurable.

    This affects the defaults within SSMS sessions for the...

    September 16, 2016 at 6:18 am

    #1901320

Viewing 15 posts - 166 through 180 (of 380 total)