Forum Replies Created

Viewing 15 posts - 76 through 90 (of 114 total)

  • RE: Convert number stored as text to number

    Do you still have else '' in your case statements?

    January 27, 2017 at 2:03 am

    #1925256

  • RE: Something I learned while unemployed

    Eric M Russell - Wednesday, January 25, 2017 8:29 AM

    Topics like unit testing, DevOps, or ETL are broadly defined and subject to...

    January 25, 2017 at 8:37 am

    #1924880

  • RE: Something I learned while unemployed

    ben.taylor.devops - Tuesday, January 24, 2017 1:53 AM

    Stefan LG - Monday, January 23, 2017 9:44 PM

    January 24, 2017 at 3:10 am

    #1924559

  • RE: Share the Interesting Work

    I give new starters the small support items at first, which gives them time to touch a lot of areas while coming up to speed. They'll get a chunky project...

    November 18, 2016 at 5:32 am

    #1913374

  • RE: Find the brackets

    Jeff Moden (11/17/2016)

    funbi (11/17/2016)

    Luis Cazares (11/17/2016)

    funbi (11/17/2016)

    The table has 7 rows.

    Real world tables don't have 7 rows. A small row count is not a valid excuse for bad code.

    It's only...

    November 17, 2016 at 11:55 am

    #1913192

  • RE: Find the brackets

    Luis Cazares (11/17/2016)

    funbi (11/17/2016)

    The table has 7 rows.

    Real world tables don't have 7 rows. A small row count is not a valid excuse for bad code.

    It's only bad code if...

    November 17, 2016 at 7:56 am

    #1913094

  • RE: Find the brackets

    Luis Cazares (11/17/2016)

    funbi (11/17/2016)

    Laurie Dunn (11/17/2016)

    This would also work and keep the code simple...

    SELECT *

    FROM dbo.MyData

    WHERE Left(mychar,1)='[';

    Yeah I got

    select * from MyData where CHARINDEX('[',mychar,0) = 1

    which works fine, then...

    November 17, 2016 at 7:32 am

    #1913065

  • RE: Find the brackets

    Laurie Dunn (11/17/2016)

    This would also work and keep the code simple...

    SELECT *

    FROM dbo.MyData

    WHERE Left(mychar,1)='[';

    Yeah I got

    select * from MyData where CHARINDEX('[',mychar,0) = 1

    which works fine, then looked at the...

    November 17, 2016 at 5:58 am

    #1913030

  • RE: INSERTing datetimeoffsets

    TomThomson (11/10/2016)

    Steve Jones - SSC Editor (11/3/2016)

    Clearly I edited an answer somewhere, causing issues. It's certainly my fault. Our interface makes checking these items hard, so I have to be...

    November 11, 2016 at 2:22 am

    #1911860

  • RE: Is order important?

    I know it's not really the point of your question but

    select count(*) from x where n % 6 = 0 and not n % 5=0

    😀

    November 4, 2016 at 3:18 am

    #1910534

  • RE: INSERTing datetimeoffsets

    (1) and (2) were both invalid.

    November 2, 2016 at 4:25 am

    #1910054

  • RE: Wasting Time

    For me the amount of meetings and interruptions I'm subjected to can be what ultimately decides if I stay in a job.

    Last job prior to current gig: had to...

    October 27, 2016 at 2:27 am

    #1909057

  • RE: Which Time Zone?

    BillLudlow (10/18/2016)

    Sorry didn't like that one Steve, totally unfamiliar with the AT TIME ZONE command, and of course I got it wrong.

    Doh!

    Not knowing what Mountain Time was didn't help either...

    October 18, 2016 at 2:23 am

    #1907065

  • RE: The Attribute

    My years spent in the xslt trenches were not in vain 😀

    October 13, 2016 at 7:18 am

    #1906311

  • RE: What do you do or think about on the way to work?

    Graham.DBA (10/12/2016)

    Have you _ever_ had a chat on the train and, at the conclusion, said 'Nice chatting with you' ?

    Is it completely silent? Going both to and from London?

    It's very...

    October 12, 2016 at 2:54 am

    #1906053

Viewing 15 posts - 76 through 90 (of 114 total)