Forum Replies Created

Viewing 15 posts - 1,291 through 1,305 (of 3,509 total)

  • 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

  • RE: Grouping and displaying of data

    Maybe use a Matrix? hard to say without more details or a dummy dataset.

    April 27, 2018 at 3:32 pm

    #1988528

  • RE: Group by month and year

    ...and post the CREATE TABLE script for the 'PersonalProfiles' table... just want to make sure that you've defined the columns properly. Using the wrong datatype could cause unexpected results.

    April 26, 2018 at 5:07 pm

    #1988411

  • RE: designing portal so we don't run into performance issues.

    NewBornDBA2017 - Thursday, April 26, 2018 2:51 PM

    My team is building a self service portal for users who want to purchase the...

    April 26, 2018 at 3:48 pm

    #1988405

    • Viewing 15 posts - 1,291 through 1,305 (of 3,509 total)