Forum Replies Created

Viewing 15 posts - 2,011 through 2,025 (of 8,731 total)

  • RE: change results orientation

    Chris Harshman (10/21/2016)

    Talvin Singh (10/21/2016)

    the first line are categories, which were created with case statements eg

    count(case when [order line] = 1 then 1 end) [1]

    Maybe I'm missing something, I'd...

    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

    October 21, 2016 at 11:36 am

    #1908044

  • RE: Today's Random Word!

    Ed Wagner (10/21/2016)

    Manic Star (10/21/2016)

    Ray K (10/21/2016)

    Ed Wagner (10/21/2016)

    Revenant (10/21/2016)

    Ed Wagner (10/21/2016)

    djj (10/21/2016)

    Luis Cazares (10/21/2016)

    crookj (10/21/2016)

    Hugo Kornelis (10/21/2016)

    Ed Wagner (10/21/2016)

    BWFC (10/21/2016)

    Ed Wagner (10/21/2016)

    djj (10/21/2016)

    Stuart Davies (10/21/2016)

    Ed Wagner (10/20/2016)

    TomThomson (10/20/2016)

    Ray K...

    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

    October 21, 2016 at 11:28 am

    #1908040

  • RE: New 'accidental' DBA-Need some guidance

    First, be sure to understand backup and restore. Then make sure that's working fine.

    Then, get this book (the pdf is free): http://www.sqlservercentral.com/articles/books/76296/

    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

    October 21, 2016 at 8:07 am

    #1907970

  • RE: Can I do this?

    So, the question remains. Do you need any more help?

    The information that you need come from the system views (sys.schemas, sys.tables, sys.columns, sys.types) or the information_schema views (which I...

    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

    October 21, 2016 at 7:57 am

    #1907965

  • RE: Today's Random Word!

    crookj (10/21/2016)

    Hugo Kornelis (10/21/2016)

    Ed Wagner (10/21/2016)

    BWFC (10/21/2016)

    Ed Wagner (10/21/2016)

    djj (10/21/2016)

    Stuart Davies (10/21/2016)

    Ed Wagner (10/20/2016)

    TomThomson (10/20/2016)

    Ray K (10/20/2016)

    Revenant (10/20/2016)

    Penny

    Nickel

    Nickelodeon

    Cartoon

    Strip

    Stripper (as in paint)

    Scrape

    Shell

    Command

    Conquer

    GDI

    GUI

    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

    October 21, 2016 at 7:36 am

    #1907954

  • RE: Can I do this?

    BLandry474 (10/21/2016)

    My apologies Brandi - you're right - you did say that in your edit. However, you also just addressed constraining the columns entry when I asked a very...

    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

    October 21, 2016 at 7:31 am

    #1907953

  • RE: Can I do this?

    Perhaps something like this can help you start?

    SELECT 'SELECT * FROM ' + t.TABLE_SCHEMA + '.' + t.TABLE_NAME

    + ' WHERE ' + STUFF(( SELECT ' OR...

    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

    October 20, 2016 at 2:43 pm

    #1907794

  • RE: Looking for help on transpose the result to be improved with pivot

    PasLe Choix (10/20/2016)

    My code again here:

    Select CutoffMonth,

    ROW_NUMBER() OVER(ORDER BY [ProjectName] ASC) AS ProjectID, [Employee Number],

    'Nov 2015',

    'Dec 2015',

    'Jan 2016',

    TotalHRSWORKED, HourlyRate

    From (Select distinct

    CutoffMonth,

    [ProjectName],

    [Employee Number],

    SUM(CASE WHEN [Mois Imputé:Cutoff Month]='Nov 2015' THEN...

    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

    October 20, 2016 at 1:37 pm

    #1907771

  • RE: Looking for help on transpose the result to be improved with pivot

    PasLe Choix (10/20/2016)

    Thank you very much for your quick reply, for unknown reason, the sum produces only CutoffMonth itself like 'Jan 2016', 'Feb 2016' instead of actually summed numbers.

    I have...

    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

    October 20, 2016 at 1:33 pm

    #1907768

  • RE: Today's Random Word!

    HappyGeek (10/20/2016)

    Grumpy DBA (10/20/2016)

    Manic Star (10/20/2016)

    djj (10/20/2016)

    Ed Wagner (10/20/2016)

    Grumpy DBA (10/20/2016)

    Ed Wagner (10/20/2016)

    djj (10/20/2016)

    Station

    Play

    Mate

    Australia

    Dingo

    Baby

    Meryl

    Streep

    Street

    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

    October 20, 2016 at 1:31 pm

    #1907766

  • RE: Looking for help on transpose the result to be improved with pivot

    Here's an example on what you might need. The explanation can be found in the following article:

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

    It's incomplete and untested, so you need to complete it and test the results...

    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

    October 20, 2016 at 1:13 pm

    #1907754

  • RE: Hide rows such as 4, 8, 14, 18, 24, 28 and so on

    That's a weird requirement. What's the story behind this?

    Here's a shorter alternative which I expect that might be a bit faster (not much).

    WITH numbers AS

    (

    SELECT ROW_NUMBER()...

    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

    October 20, 2016 at 10:29 am

    #1907715

  • RE: Parameter on Powershell Script

    Brandie Tarvin (10/20/2016)

    Luis Cazares (10/20/2016)

    mister.magoo (10/20/2016)

    I was wondering whether all this complexity is worth it...just to run a dtsx? But I'm not a DBA, so I assume this is a...

    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

    October 20, 2016 at 9:46 am

    #1907700

  • RE: 2016 Features - Enterprise Edition versus Standard

    You can check this: https://www.microsoft.com/en-us/sql-server/sql-server-editions

    That also links to the more detailed document here: https://msdn.microsoft.com/en-us/library/cc645993.aspx

    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

    October 20, 2016 at 9:13 am

    #1907689

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (10/20/2016)

    jasona.work (10/20/2016)

    Brandie Tarvin (10/20/2016)

    I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server. One is ~134GB...

    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

    October 20, 2016 at 8:33 am

    #1907678

Viewing 15 posts - 2,011 through 2,025 (of 8,731 total)