Forum Replies Created

Viewing 15 posts - 3,901 through 3,915 (of 8,731 total)

  • RE: DY

    Steve Jones - SSC Editor (11/6/2015)

    Luis Cazares (11/6/2015)

    Aren't those self explanatory? If they don't know the difference, selecting the function and pressing F1 will take them to the page on...

    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

    November 6, 2015 at 10:53 am

    #1838300

  • RE: Are the posted questions getting worse?

    xsevensinzx (11/6/2015)

    I would agree, knowing at least GETDATE() or it's existence is a given. I just didn't think that was the question because who in the hell is applying for...

    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

    November 6, 2015 at 8:32 am

    #1838254

  • RE: DY

    sknox (11/6/2015)

    Luis Cazares (11/6/2015)

    Rich Mechaber (11/6/2015)

    Aaron Bertrand had a nice blog about this: scroll down for "Pop Quiz" and see if you still think DATEPART abbreviations are straightforward.

    Rich

    2 letter abbreviations...

    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

    November 6, 2015 at 8:24 am

    #1838250

  • RE: DY

    Sean Lange (11/6/2015)

    Luis Cazares (11/6/2015)

    Rich Mechaber (11/6/2015)

    Aaron Bertrand had a nice blog about this: scroll down for "Pop Quiz" and see if you still think DATEPART abbreviations are straightforward.

    Rich

    2 letter...

    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

    November 6, 2015 at 8:11 am

    #1838243

  • RE: How to fix "Divide by zero error" in SQL Server

    priterande (11/5/2015)

    select COALESCE(MIN(Act) / NULLIF(MAX(Act),0), 0) as minvsmaxAct from table_name

    This is what I usually do, except that I don't reply to 5 year old threads. :w00t:

    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

    November 6, 2015 at 7:56 am

    #1838237

  • RE: DY

    Rich Mechaber (11/6/2015)

    Aaron Bertrand had a nice blog about this: scroll down for "Pop Quiz" and see if you still think DATEPART abbreviations are straightforward.

    Rich

    2 letter abbreviations are straightforward, single...

    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

    November 6, 2015 at 7:42 am

    #1838234

  • RE: Are the posted questions getting worse?

    Ed Wagner (11/6/2015)

    Brandie Tarvin (11/6/2015)

    xsevensinzx (11/6/2015)

    Jeff Moden (11/5/2015)

    Precisely. I couldn't have said it better myself. It's a bit like interviewing a mechanic. If they can't describe the...

    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

    November 6, 2015 at 6:52 am

    #1838204

  • RE: DY

    henrik staun poulsen (11/6/2015)

    Hi Steve,

    I think the answer should state that it is a lot safer to just write "DayOfYear" in your code.

    This also makes the code easier to read.

    Best...

    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

    November 6, 2015 at 6:48 am

    #1838203

  • RE: Find All Items That Call a Stored Procedure

    andrew.mills 44498 (11/5/2015)

    Luis: thank you for the help, but unfortunately this didn't help. I searched the folder in question for the stored procedure, and Notepad++ wasn't able to...

    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

    November 5, 2015 at 1:34 pm

    #1838096

  • RE: Alternative for len() function in where clause

    Maybe this can prove that LEN() is better than avoiding functions when filtering by length. Even when avoiding functions, you'll get an index scan.

    CREATE TABLE #LengthTest(

    String...

    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

    November 5, 2015 at 12:51 pm

    #1838085

  • RE: extracting data from SQL database

    Once you can create the query to return all the information, you can program it to export it to a single file automatically.

    Some problems you can find is when you...

    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

    November 5, 2015 at 9:21 am

    #1838025

  • RE: Today's Random Word!

    anthony.green (11/5/2015)

    Igor Micev (11/5/2015)

    crookj (11/5/2015)

    Ed Wagner (11/5/2015)

    anthony.green (11/5/2015)

    TomThomson (11/4/2015)

    DonlSimpson (11/4/2015)

    Weak

    frail

    Old

    Experience

    Familiarity

    Information

    Announcement

    Billboard

    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

    November 5, 2015 at 8:44 am

    #1837999

  • RE: extracting data from SQL database

    You can, but you need to know how the tables are designed, define what you want to retrieve and create adequate queries.

    An incorrect query will work and give incorrect data,...

    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

    November 5, 2015 at 8:42 am

    #1837998

  • RE: Find All Items That Call a Stored Procedure

    When I had a similar problem trying to find out which packages used certain tables, I used "Find in Files" option (Ctrl+Shift+F) in Notepad++.

    Of course, this only works if the...

    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

    November 5, 2015 at 8:36 am

    #1837995

  • RE: Create Procedure

    tom.w.brannon (11/4/2015)

    tom.w.brannon (11/4/2015)

    I answered All of the Above because I understood it to be about practices, not syntax. I agree with others that bad syntax will be avoided because...

    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

    November 4, 2015 at 11:09 am

    #1837754

Viewing 15 posts - 3,901 through 3,915 (of 8,731 total)