Forum Replies Created

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

  • 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...

    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...

    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...

    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:

    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...

    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...

    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...

    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...

    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...

    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...

    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

    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,...

    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...

    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...

    November 4, 2015 at 11:09 am

    #1837754

  • RE: Query Performance tuning for cursor

    Junglee_George (11/4/2015)

    Hey, This is how I tuned my query to avoid cursor in my code. Hope it helps. ...

    If any suggestions are there, all are welcome.

    My suggestion is for you...

    November 4, 2015 at 10:15 am

    #1837739

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