Forum Replies Created

Viewing 15 posts - 2,716 through 2,730 (of 8,731 total)

  • RE: Displaying Column Data Horizontally Using Pivot Table

    SQLUSERMAN (6/9/2016)

    I have unpivot the table and although the result is getting close to what I need, it is still not what I want.

    Below is the query I've used, please...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 9, 2016 at 2:04 pm

    #1884236

  • RE: Tools to load fields into a query

    You could use SSIS for that. To create the packages more easily, you could use the Import/Export wizard.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 9, 2016 at 1:31 pm

    #1884225

  • RE: Today's Random Word!

    Ed Wagner (6/9/2016)

    Manic Star (6/9/2016)

    crookj (6/9/2016)

    Luis Cazares (6/9/2016)

    Manic Star (6/9/2016)

    Ed Wagner (6/8/2016)

    crookj (6/8/2016)

    Revenant (6/8/2016)

    Y.B. (6/8/2016)

    Ed Wagner (6/8/2016)

    TomThomson (6/8/2016)

    HappyGeek (6/8/2016)

    Skinflint

    Pinchpenny

    Cheap

    Me 😉

    Windows ME

    Barf

    Agree

    Fight

    Club

    Sgt Pepper's (Lonely Hearts #### Band)

    Abby (Road)

    Downton

    Uptown

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 9, 2016 at 12:49 pm

    #1884215

  • RE: Multi Column Date Between Statment

    Lynn Pettis (6/9/2016)

    Sean Lange (6/9/2016)

    This still is not really very clear what you are trying to do but here is my shot in the dark. You are looking for rows...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 9, 2016 at 12:34 pm

    #1884211

  • RE: Displaying Column Data Horizontally Using Pivot Table

    You need to unpivot before pivoting again. This can be done in a single statement.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 9, 2016 at 11:56 am

    #1884194

  • RE: Multi Column Date Between Statment

    Would this article give you the answer you're looking for?

    http://www.sqlservercentral.com/articles/T-SQL/105968/

    It mentions month, but should work for any range.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 9, 2016 at 11:25 am

    #1884175

  • RE: Need logic behind the below 5 statements

    Each statement is assigning a value to a variable. This values will be lost after the batch ends, so basically, they're not doing anything useful unless they're combined with something...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 9, 2016 at 11:22 am

    #1884173

  • RE: Today's Random Word!

    Manic Star (6/9/2016)

    Ed Wagner (6/8/2016)

    crookj (6/8/2016)

    Revenant (6/8/2016)

    Y.B. (6/8/2016)

    Ed Wagner (6/8/2016)

    TomThomson (6/8/2016)

    HappyGeek (6/8/2016)

    Skinflint

    Pinchpenny

    Cheap

    Me 😉

    Windows ME

    Barf

    Agree

    Fight

    Club

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 9, 2016 at 9:41 am

    #1884145

  • RE: Are the posted questions getting worse?

    Y.B. (6/9/2016)

    Greg Edwards-268690 (6/9/2016)

    Y.B. (6/9/2016)

    So what do you say when your boss announces in a meeting that 'we' should look into NoSQL? No really...what do you say?

    I realize that...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 9, 2016 at 9:37 am

    #1884144

  • RE: Exclude weekend hours from datediff() function

    Just remember that you might want to consider holidays as well. That's only achievable from a holidays or calendar table.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 9, 2016 at 9:32 am

    #1884143

  • RE: Running Totals,

    This is what I understood from what you posted, or at least it makes some logic to me. I agree with Drew that you might want to use a calendar...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 9, 2016 at 9:27 am

    #1884141

  • RE: Are the posted questions getting worse?

    Y.B. (6/9/2016)

    So what do you say when your boss announces in a meeting that 'we' should look into NoSQL? No really...what do you say?

    I realize that there are good...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 9, 2016 at 8:28 am

    #1884116

  • RE: Query taking 6 hrs and counting (HELP!)- how to concatenate rows into single string

    Sergiy (6/8/2016)

    Luis Cazares (6/8/2016)

    I mentioned that because he stated the following:

    Thanks, that works abit faster but its still very slow. 16hrs and no where near done

    Now, even with the DISTINCT,...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 8, 2016 at 8:50 pm

    #1884051

  • RE: Query taking 6 hrs and counting (HELP!)- how to concatenate rows into single string

    I mentioned that because he stated the following:

    Thanks, that works abit faster but its still very slow. 16hrs and no where near done

    Now, even with the DISTINCT, it shouldn't perform...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 8, 2016 at 7:46 pm

    #1884046

  • RE: Interview Questions Help

    Jeff Moden (6/8/2016)

    prafuljemail (6/7/2016)

    check interview questions on forums of winmilestone.com / http://www.winmilestone.com/Topic?Interview

    You want way too much information on the signup sheet. It's not worth it.

    Not only that, the page...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 8, 2016 at 4:13 pm

    #1884037

Viewing 15 posts - 2,716 through 2,730 (of 8,731 total)