Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: SQLServerCentral apologizes and you can win a book

    I love his books and most valuable in practical life. Like to have this one.

    WITH CTE (Rank_Number,row_date,PBXACD_ID,split,center_id) AS

    (SELECT

    RANK() OVER ( PARTITION BY row_date, PBXACD_ID, split ORDER BY COUNT(*) DESC) AS...

  • RE: SQLServerCentral apologizes and you can win a book

    I love Itzik Ben-Gan's books, very valuable in practical life.

    WITH CTE (Rank_Number,row_date,PBXACD_ID,split,center_id) AS

    (SELECT

    RANK() OVER ( PARTITION BY row_date, PBXACD_ID, split ORDER BY COUNT(*) DESC) AS Rank_Number,

    row_date,

    PBXACD_ID,

    split,

    center_id

    FROM

    TestDB.dbo.TestTable (NOLOCK)

    WHERE

    row_date >= CAST(DATEADD(day, -3,...

Viewing 2 posts - 1 through 2 (of 2 total)