Forum Replies Created

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

  • Reply To: How to rank the records

    Yes Sir, Dense rank does skip the consecutive numbers.

    November 22, 2020 at 10:12 pm

    #3812797

  • Reply To: How to rank the records

    Awesome

    November 22, 2020 at 7:29 pm

    #3812769

  • Reply To: How to rank the records

    Thanks SSCU guru point taken.

    I ran the query and it s returning

    rank1

     

    What I am looking for is , I want to rank orderno within each item category

     

    November 22, 2020 at 6:08 pm

    #3812747

  • RE: get date by rank

    jcelko212 32090 - Friday, March 23, 2018 10:17 AM

    Angela4eva - Wednesday, March 21, 2018 9:06 AM

    March 23, 2018 at 12:46 pm

    #1984451

  • RE: get date by rank

    GilaMonster - Wednesday, March 21, 2018 10:36 AM

    Using Pietlinden's sample tables above (thanks), this looks like it should give what's wanted.

    [code...

    March 21, 2018 at 11:06 am

    #1984178

  • RE: get date by rank

    GilaMonster - Wednesday, March 21, 2018 10:22 AM

    If they're datetimes (not strings) it won't matter to SQL what they are. I'm not...

    March 21, 2018 at 10:31 am

    #1984170

  • RE: get date by rank

    GilaMonster - Wednesday, March 21, 2018 10:10 AM

    So for both of these, it should return the 3rd Feb?

    (22, 200, 2, '01/01/2018')
    (53, 90,...

    March 21, 2018 at 10:19 am

    #1984164

  • RE: get date by rank

    pietlinden - Wednesday, March 21, 2018 9:46 AM

    Looks like this worked...
    use tempdb;
    GO

    CREATE TABLE PayDates(PayDate DATE PRIMARY KEY);
    GO
    INSERT INTO PayDates(PayDate) VALUES...

    March 21, 2018 at 10:04 am

    #1984160

  • RE: Spilt a record into 4

    this is awesome thank you

    March 21, 2018 at 8:58 am

    #1984140

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