Forum Replies Created

Viewing 15 posts - 2,566 through 2,580 (of 5,109 total)

  • RE: SOS

    It's certainly interesting, if nothing else. At home it's really useful, as I'm a Linux user, so I don't have to rely on VS Code with the MS SQL extension,...

    Thom~

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

  • RE: Excel drivers for ssis package

    sqlsniffer - Friday, November 17, 2017 2:56 AM

    Hi,
    I checked out, and I have 32 bit ACE installed and my windows is...

    Thom~

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

  • RE: Excel drivers for ssis package

    sqlsniffer - Friday, November 17, 2017 2:54 AM

    Phil Parkin - Tuesday, November 14, 2017 10:37 AM

    Thom~

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

  • RE: Querying specific values in column that's using XML data

    So, with the data provided, what results are you expecting?

    Thom~

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

  • RE: Installation of Reporting services on separate machine

    You'll need licences for the Server that is hosting the databases (and running the data engine) AND licences for the Server that is running the Reporting Services Service. The Web...

    Thom~

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

  • RE: Querying specific values in column that's using XML data

    I have to agree with Steve, I'm not a fan of XQuery. I (normally) have to look up the syntax each and every time I have to use it.

    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?

    Jack Corbett - Thursday, November 16, 2017 8:09 AM

    Chris Harshman - Monday, November 13, 2017...

    Thom~

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

  • RE: Combine rows by applying grouping and data validation

    KapilT - Thursday, November 16, 2017 7:52 AM

    Hello Thom,

    Thanks for guidance! will follow the practice in future.
    Logic
    1. Result Expected from MeetingDetails master table. --Meeting Details...

    Thom~

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

  • RE: Combine rows by applying grouping and data validation

    Hi Kapil,

    When posting T-SQL questions, please avoid supplying your data and expected results in an excel Document; you'll find many people will not be happy to open the...

    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?

    Microsoft SQL Operations Studio (MSOS) preview is out. Gave it a quick install before I headed out. Looks very much like VSCode. Shall see what I think, but at least...

    Thom~

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

  • RE: Update Duplicate Records dynamically

    The logic is the same as above, but instead set your value to that of your RN. This suggests you don't quite understand what the solution I supplied does; do...

    Thom~

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

  • RE: How to resolve one to many linkage

    drew.allen - Wednesday, November 15, 2017 9:21 AM

    There are two main approaches, both of which have already been suggested.  Which one performs...

    Thom~

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

  • RE: How to resolve one to many linkage

    How about using a CROSS APPLY:

    SELECT *
    FROM Client...

    Thom~

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

  • RE: Update Duplicate Records dynamically

    This is a a bit of guess work, as your table as a PRIMARY_KEY and Version column with the same values. As we only have 1 example, guessing that the...

    Thom~

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

  • RE: SP_WhoIsActive SQL Server 2000

    I realise that you said that upgrading is not an option, but may I ask why? Personally, I would consider SQL Server 2000 to be a significant risk to the...

    Thom~

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

Viewing 15 posts - 2,566 through 2,580 (of 5,109 total)