Forum Replies Created

Viewing 15 posts - 3,046 through 3,060 (of 5,109 total)

  • RE: Insert fails when trying to create a table.

    newdba2017 - Wednesday, September 27, 2017 1:03 PM

    Phil Parkin - Wednesday, September 27, 2017 12:27 PM

    Thom~

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

  • RE: Automate Table Field Names In Query

    Danie8 - Wednesday, September 27, 2017 8:12 AM

    Hi Steve,
    I agree with you that  "Continuing to support this kind of data structure is in...

    Thom~

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

  • RE: SSRS SCOM Alert: SSRS 2012: Other processes use too much memory

    The fact that you haven't set it may be your answer, and thus SSRS is using the default. Why not try setting the value to a figure in your config...

    Thom~

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

  • RE: Start of month last year

    craig.jenkins - Wednesday, September 27, 2017 8:03 AM

    Thanks for that, i have amended to the below buts its not bring back the...

    Thom~

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

  • RE: Start of month last year

    Phil Parkin - Wednesday, September 27, 2017 7:08 AM

    Not sure what you mean by "last year's date". This seems too obvious:

    Thom~

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

  • RE: How to add a COUNT value against unique name returns

    Also, what is the need for your LEFT JOIN to the table DB1_GroupEmployees? You don't reference the table in your SELECT or WHERE clause, and the fact that...

    Thom~

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

  • RE: How to add a COUNT value against unique name returns

    Welcome to SSC.

    When posting T-SQL questions, you need to ensure you provide DDL, DLM and expected outputs. We don't have access to your data, Server, etc, so simply...

    Thom~

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

  • RE: Trim off trailing letters

    alan.leow - Wednesday, September 27, 2017 2:38 AM

    Hi John / Thom,
    I think there's no need to copy any data. I have a...

    Thom~

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

  • RE: Trim off trailing letters

    alan.leow - Wednesday, September 27, 2017 1:53 AM

    Oh... i forgot to explain that the reference number varies, yes it is not fixed...

    Thom~

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

  • RE: Automate Table Field Names In Query

    If your column names are always in flux, then how are you proposing you INSERT data into them if you don't know what columns are going to be present. You...

    Thom~

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

  • RE: Trim off trailing letters

    alan.leow - Tuesday, September 26, 2017 10:17 PM

    Hi all,

    I need to trim off whichever letters are at the end of a reference...

    Thom~

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

  • RE: Restore MySQL dump? help

    This is a (Microsoft) SQL Server Forum, not MySQL. You'd be better posting on a website dedicated to MySQL, or (as much as I dislike it) Stack Overflow for an...

    Thom~

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

  • RE: Error 2812 : Unable to create new login or resest login password

    I assume you're logged in with an account with sufficient privileges to create and/or change a login?

    Thom~

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

  • RE: Substring

    hoseam - Tuesday, September 26, 2017 1:04 AM

    They are csv files, e.g File 1, Name: Generate20170913100320;  File 2, Name: Generate20170914110420

    So, based on your (couple...

    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?

    Tom_Hogan - Monday, September 25, 2017 12:29 PM

    According to the asterisk, SQL Server 2017 will be available for download on October 2nd.

    Thom~

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

Viewing 15 posts - 3,046 through 3,060 (of 5,109 total)