Forum Replies Created

Viewing 15 posts - 1 through 15 (of 30 total)

  • RE: WMI connection error using Invoke-Sqlcmd

    I'm trying to learn a new skill. I've never used powershell before. I thought using existing cmd batch routines Ive written as a good project to start with.

  • RE: Avoiding Unexpected Results with DATEDIFF in Year Comparisons

    I use this code to work out Age
    DECLARE @DateOfBirth DATETIME = '1980-07-12';
     DATEDIFF(YEAR, @DateOfBirth, GETDATE())
     - CASE
      WHEN (MONTH(@DateOfBirth) > MONTH(GETDATE()))

  • RE: Does Your Work Attire Really Make a Difference?

    Where I work it is casual wear.  We are pretty much free to wear what we want, within reason.  Some people wear jeans, trainers and possibly a rock t-shirt etc. ...

  • RE: Presentations that are Easy on the Eyes

    For day in day out coding I prefer a dark background with pastel like code colouring as it is a lot easier on the eyes.  Here's an example of mine.

  • RE: Removing Reverse Duplicates

    jcelko212 32090 - Tuesday, April 11, 2017 12:15 PM

    DesNorton - Wednesday, April 5, 2017 10:08 AM

    April 12, 2017 at 2:58 am


  • RE: Removing Reverse Duplicates

    J Livingston SQL - Wednesday, April 5, 2017 9:57 AM

    for these records

    10000003 | 10000004 
    10000005 | 10000006 

    why arent there corresponding reverse entries?.......or am...

  • RE: Removing Reverse Duplicates

    Thanks for that, but it's not quite there.  I still wish to retain one of the 2 duplicates.  This code removes both rows. I need one of the rows to...

  • RE: How Much Code Can You Review?

    We have a review process here that goes something like this:

    * Issue raised by the client
    * Incident log is then created
    * Development item created and assigned...

  • RE: Quick question regarding UNION

    That's exactly what I'm going to ask the Python developers to do.

    Essentially, the whole process that gets us to this stage is a SQL databse being prepared and migrated from...

  • RE: Quick question regarding UNION

    OOPs, that's my fault, ignore the commas at the end (i've edited my above post now)

    The __clients and __entity_asset tables have no indexes. They get created by a python...

  • RE: Quick question regarding UNION

    I think i've figured this out. The execution plan suggested the JOINs were the issue so I asked for the TSQL code.

    He's got the following no no's as far as...

  • RE: Quick question regarding UNION

    Thanks guys, I've asked him to get the execution plan.

    If I struggle to see the issue, I'll get some DDL together.

  • RE: Round averages

    morlindk (9/29/2016)

    I think 'None of these queries' is correct.

    (i) Table has Score, queries reference TestScore => Error

    (ii) Even option 3 produces '9', not '9.0'


    I think the correct answer is...

  • RE: What Helps You Learn?

    ZZartin (9/23/2016)

    I'm also one of those people who learns by doing, I can read a book on a subject cover to cover and retain/understand how to apply none of it....

  • RE: What Helps You Learn?

    I find I learn more and retain more knowledge through "doing". I watch and read tutorials all the time, and they stick partly with me until I am doing...

Viewing 15 posts - 1 through 15 (of 30 total)