Forum Replies Created

Viewing 15 posts - 2,221 through 2,235 (of 5,109 total)

  • RE: Help me with for Xml path()

    What is your defining logic that data for HSBC and JPMORGON be in the same result? Is it because of the column with "XML_1_2" in it? Do you define...

    Thom~

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

  • RE: GUI for SQL on Linux?

    On Linux, no. Unfortunately Microsoft are quite far behind for tools on the Linux Side. You do have SQL Operations Studio, which is currently in preview, but it's a long...

    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?

    Sean Lange - Wednesday, February 14, 2018 7:29 AM

    I was scared to look but wow. They need to find another line...

    Thom~

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

  • RE: how to get detail error information using execute process task and handle exit code was “2” while the expected was “0”. in ssis

    2 is a code that the application is returning to SSIS, in this case 7z.exe. Normally, when an application successfully completes it returns the code 0 (which, by default is...

    Thom~

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

  • RE: #Error when converting HH:MM:SS to seconds using expression

    You don't explain what your goal is here, nor do we have any data to work with. All we know is that your code generates an error; this doesn't tell...

    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?

    drew.allen - Friday, February 9, 2018 11:16 AM

    Why do so many people think that "it doesn't work for me" is a sufficient...

    Thom~

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

  • RE: Password policy for system logins

    If the account is being used by a application, website, etc, then they are service accounts, not System Accounts. Generally, service account passwords aren't set to expire; otherwise, when they...

    Thom~

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

  • RE: Pivot in SSMS porting to SSRS

    pietlinden - Friday, February 9, 2018 9:17 AM

    Thom A - Friday, February 9, 2018 9:00 AM

    Thom~

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

  • RE: Pivot in SSMS porting to SSRS

    "it didn't work for me"? What do you mean? Did you get an error, unexpected results? You didn't like what you saw?

    Rather than using a SQL query to...

    Thom~

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

  • RE: What to Read in 2018

    GilaMonster - Friday, February 9, 2018 5:35 AM

    Thom A - Friday, February 9, 2018 3:38 AM

    Thom~

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

  • RE: What to Read in 2018

    Glad to see Arcanum Unbound is there; Brandon Sanderson is a fantastic author and I couldn't have asked for a better author to finish the Wheel of Time series. He...

    Thom~

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

  • RE: Need help with SQL select query.

    This would much more easily achieved using something like SSRS. You can put an expression on the column then, and hide it if the count of the values in the...

    Thom~

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

  • RE: Add constraint to an existing table column

    vijay.fulwar12 - Monday, February 5, 2018 4:12 AM

    How to add a default constraint date to a Column of an existing table.

    Search Engines...

    Thom~

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

  • RE: How to use dynamic pivot on this data

    With the data you've provided, could you show what you want your expected result set to be?

    Thom~

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

  • RE: Data roll up

    You know by now how to post a T-SQL question. Please supply DDL and Consumable Sample Data.

    Thom~

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

Viewing 15 posts - 2,221 through 2,235 (of 5,109 total)