Forum Replies Created

Viewing 15 posts - 106 through 120 (of 161 total)

  • RE: How Do You Keep The "Pieces" Of A Complex Statement "Organized"

    EdA ROC (9/27/2012)

    Stop The Presses... My Thread has been hijacked. 🙂

    Would you please take this REFERENCES conversation to another thread?

    Sorry about that. :blush: We don't need a new...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    September 27, 2012 at 11:42 am

    #1543028

  • RE: How Do You Keep The "Pieces" Of A Complex Statement "Organized"

    Jeff Moden (9/27/2012)

    LightVader (9/27/2012)

    CELKO (9/27/2012)

    The only REFERENCES keyword I know is in creating foreign keys and since foreign keys can be NULL, I'm not sure how that would eliminate the...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    September 27, 2012 at 11:03 am

    #1543017

  • RE: How Do You Keep The "Pieces" Of A Complex Statement "Organized"

    CELKO (9/27/2012)

    The only REFERENCES keyword I know is in creating foreign keys and since foreign keys can be NULL, I'm not sure how that would eliminate the LEFT OUTER JOIN....


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    September 27, 2012 at 10:50 am

    #1543002

  • RE: How Do You Keep The "Pieces" Of A Complex Statement "Organized"

    CELKO (9/22/2012)

    ...

    For example, when you say “LEFT OUTER JOIN Grade_File AS GF ON GF.grade_cd = S.grade_cd” probably should have been done with a REFERENCES in the DDL and not with...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    September 24, 2012 at 8:47 am

    #1541449

  • RE: Reporting source which way do you prefer it

    We try to stick with stored procedures. All the logic is contained within the stored procedure, plus IMHO, it's much easier to edit the script in SSMS then in...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    August 3, 2012 at 6:15 am

    #1521334

  • RE: SQL Install Order - Is it Important?

    Arjen Krap (7/29/2012)

    sqlnovice2001 (7/24/2012)

    Thanks for the quick reply. As to the install question. Does it matter that SQL 2008 is already installed prior to installing SQL 2005? Any gotchas?

    ...

    Beside this...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    July 30, 2012 at 10:40 am

    #1519285

  • RE: Geeky Books

    I read Wired and it's sequel Amped by Douglas E. Richards. Both were excellent although I enjoyed Wired a bit more. I tend to stick to sci fi...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    July 19, 2012 at 5:57 am

    #1514772

  • RE: I left all my scripts at my previous employer

    bobt 46978 (6/15/2012)

    A memory stick.

    It's been 5 years and I haven't seen the 'HR lady with a box' yet, but if I do, the memstick gets stashed away, first thing.

    Make...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    June 19, 2012 at 7:25 am

    #1502822

  • RE: Cube Goodies

    A few of my coworkers organize office parties a few times of year. We'll order in for Cinco de Mayo, decorate for halloween and Christmas. And then there's...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    June 19, 2012 at 7:23 am

    #1502819

  • RE: Index defaults 1

    ronmoses (6/14/2012)

    L' Eomot Inversé (6/14/2012)

    Most of those errors were the same wrong answer, there appears to a widely distributed myth that any primary index is clustered unless it is declared...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    June 14, 2012 at 6:40 am

    #1500945

  • RE: Display 4 parameters in one line - Parameter's Panel

    On Report Server 2008, you can hide the parameter area. Take a look at the picture I attached. In the dark blue bar below the report parameters, there's...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    June 14, 2012 at 6:33 am

    #1500942

  • RE: Does studying a Masters give you an edge in the employment stakes?

    michaeljharper (6/5/2012)

    On balance it seems the best bet is to apply for jobs when I graduate and get some experience in the field, I'm pretty sure many companies provide in...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    June 5, 2012 at 11:53 am

    #1497244

  • RE: Does studying a Masters give you an edge in the employment stakes?

    michaeljharper (6/5/2012)

    ACinKC (6/5/2012)

    LightVader is spot on, from my perspective. Around here, you'll find more people getting their undergraduate degree, getting into the workforce, spending some time "in the trenches,"...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    June 5, 2012 at 9:38 am

    #1497142

  • RE: can we get this guy banned from the forums?????

    Lynn Pettis (6/5/2012)

    LightVader (6/5/2012)

    Michael Valentine Jones (5/24/2012)

    Brevity and obscurity

    declare @ char(3)

    set @=0

    while @<100

    begin

    set @=@+1

    print

    case when @%15=0 then 'FizzBuzz'

    when @%3=0 then 'Fizz'

    when @%5=0 then 'Buzz'

    else @ end

    end

    I didn't realize that you...


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    June 5, 2012 at 6:59 am

    #1497022

  • RE: Does studying a Masters give you an edge in the employment stakes?

    I'm in US. I went right from my Bachelor's degree to the working environment. To be honest, I wasn't entirely sure what kind of Master's degree I wanted....


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.

    June 5, 2012 at 6:31 am

    #1497006

Viewing 15 posts - 106 through 120 (of 161 total)