Forum Replies Created

Viewing 15 posts - 1,516 through 1,530 (of 5,109 total)

  • RE: Encrypted Password

    BCP doesn't support encrypted passwords. If you're passing the password in the command, it needs to be the literal value.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Adding multiple subreports to blank main report

    NineIron - Thursday, October 25, 2018 5:18 AM

    I have a main report without any dataset and want to add multiple subreports to...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: NOT IN vs NOT EXISTS

    Perhaps my initial post mislead people, but the query in my initial post wasn't what was being "debated", when i was informed that NOT EXISTS is "the worst option", it...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Help with SQL Queries

    tempdownloads - Thursday, October 25, 2018 4:40 AM

    (This seems to be a SELF JOIN?)
    SELECT t.training_days, COUNT(t.athleteID AS 'training_days' FROM track_table t
    WHERE t.training_days...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Help with SQL Queries

    tempdownloads - Thursday, October 25, 2018 4:04 AM

    I could use some help on question 3 please?

    Here's the code to...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Newbie: SQL Query Help

    Direct answers to duplicate here: https://www.sqlservercentral.com/Forums/2006233/Help-with-SQL-Queries

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Help with SQL Queries

    This looks like you're asking for homework validation. Have you spoken to your tutor? Also, all the questions state "Create a table/column", however, every solution you've provided are SELECT statements...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor - Wednesday, October 24, 2018 8:54 AM

    I dislike when I've asked what they've done and someone...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: NOT IN vs NOT EXISTS

    Brandie Tarvin - Wednesday, October 24, 2018 8:46 AM

    Okay, so I do have an additional question. Why use the specific WHERE clauses...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: NOT IN vs NOT EXISTS

    Jonathan AC Roberts - Wednesday, October 24, 2018 7:50 AM

    Oh, I hadn't read the full post.
    I always use NOT EXISTS over...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: NOT IN vs NOT EXISTS

    Jonathan AC Roberts - Wednesday, October 24, 2018 7:33 AM

    I'm just wondering why you didn't include  "AND

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Are the posted questions getting worse?

    Realise my post is a bit "ranty", but if anyone has input here, I'd greatly appreciate it: https://www.sqlservercentral.com/Forums/2006029/NOT-IN-vs-NOT-EXISTS

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Coming from Oracle - How Do I Do This Date Conversion in SQLServer?

    drew.allen - Tuesday, October 23, 2018 9:51 AM

    Thom A - Friday, October 5, 2018 7:51 AM

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Display 'blank' cell when it is null.

    Jonathan AC Roberts - Saturday, October 20, 2018 11:17 AM

    Thom A - Saturday, October 20, 2018 11:02...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Display 'blank' cell when it is null.

    saravanatn - Saturday, October 20, 2018 9:16 AM

    Jonathan AC Roberts - Friday, October 19, 2018 3:38 PM

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 15 posts - 1,516 through 1,530 (of 5,109 total)