Forum Replies Created

Viewing 15 posts - 1,261 through 1,275 (of 3,482 total)

  • RE: Calculate timespan between datetime field in multiple records

    Could you post some sample data - insert statements so we have something to work with? Basically, you can use LAG with a window to get the "previous" record, and...

    July 10, 2018 at 3:11 am

    #1996913

  • RE: T-SQL help needed to eliminate duplicates from table

    Maybe this?
    SELECT member,
        amt_paid,
        amt_adjusted,
        dt,
        dupeNum
    FROM
    ( SELECT member,
        amt_paid,
        amt_adjusted,
        dt,
        ROW_NUMBER() OVER (PARTITION BY member, dt, amt_adjusted ORDER BY member, dt) AS dupeNum

    June 11, 2018 at 10:14 am

    #1993578

  • RE: T-SQL help needed to eliminate duplicates from table

    mw_sql_developer - Monday, June 11, 2018 9:46 AM

    pietlinden - Sunday, June 10, 2018 5:08 PM

    June 11, 2018 at 10:12 am

    #1993577

  • RE: T-SQL help needed to eliminate duplicates from table

    Kinda would help if I wrote an actual delete query... =)
    Test the CTE out by doing SELECT from it first instead of DELETE
    ;WITH
        cteMembers(member, amt_paid,...

    June 10, 2018 at 7:02 pm

    #1993499

  • RE: Export to Excel

    jagjitsingh - Sunday, June 10, 2018 2:50 AM

    Hi
     I want Data from the Sql table to Excel in predefined Excel Template . I...

    June 10, 2018 at 5:09 pm

    #1993498

  • RE: T-SQL help needed to eliminate duplicates from table

    Like this? It's not super clear what you want. In this case, a sample expected result would be a big help.  Something like this?
    Create table #t( member...

    June 10, 2018 at 5:08 pm

    #1993497

  • RE: Query

    jagjitsingh - Sunday, May 27, 2018 10:44 AM

    Hi

      I have below Data .

    May 18, 2018 at 2:40 pm

    #1991086

  • RE: How do you keep yourself from burning out?

    I agree with the "do something that's engrossing that's totally outside of work" - I did that and it kept me sane. Work was crazy, so I'd spend like 15...

    May 17, 2018 at 12:38 pm

    #1990910

  • RE: simple select * from table takes around 15 secons

    Thom A - Thursday, May 17, 2018 11:24 AM

    pietlinden - Thursday, May 17, 2018 11:22 AM

    May 17, 2018 at 11:54 am

    #1990904

  • RE: simple select * from table takes around 15 secons

    if you look in a phone book for everybody with "S" as the second letter of their last name, an index is meaningless, because a phone book is organized alphabetically....

    May 17, 2018 at 11:22 am

    #1990895

  • RE: Checking Fulfillment of Prerequisites That Can Contain Elaborate AND/OR Relationships

    I really shouldn't take the bait...

    If you create the prerequisites table, this isn't too hard. I still am not totally clear on how you group ORs.  How would...

    May 16, 2018 at 2:31 pm

    #1990737

  • RE: always include value in filter?

    Re-reading my question, you're right... that's not answerable as stated.  I'm doing this in PowerBI / DAX, so I have a simple star schema with Customers and Sales ... 

    May 12, 2018 at 4:37 pm

    #1990275

  • RE: Employee Time Clock

    Henric,
    Nice post for a rookie. Welcome to SSC.  Here's a script to create the table and populate it with some data... I added a few extra records to make...

    May 3, 2018 at 10:43 pm

    #1989224

  • RE: Grouping and displaying of data

    LOL. I just did that yesterday... except it was above my head.

    April 27, 2018 at 4:00 pm

    #1988531

    • Viewing 15 posts - 1,261 through 1,275 (of 3,482 total)