Forum Replies Created

Viewing 15 posts - 2,521 through 2,535 (of 13,877 total)

  • Reply To: SQL Query Help - CHARINDEX

    Try this:

    SELECT t1.*
    FROM #Test1 t1
        CROSS APPLY STRING_SPLIT(t1.SName, '/') ss
        JOIN #Test2 t2
            ON...

    July 20, 2020 at 7:47 pm

    #3771494

  • Reply To: how to replace uncounted multiple commas into one comma

    Infallible, unless the original text contains some combinations of angled brackets, in which case alternative 'dummy characters' may be employed, for example:

    SELECT t.SomeString
        ...

    July 20, 2020 at 4:32 pm

    #3771403

  • Reply To: how to replace uncounted multiple commas into one comma

    There's now a well-known solution to this problem which requires no non-standard functions:

    DROP TABLE IF EXISTS #Test;

    CREATE TABLE #Test
    (
        SomeString VARCHAR(500)
    );

    INSERT #Test
    (
      ...

    July 20, 2020 at 4:13 pm

    #3771400

  • Reply To: Out of memory error when I try to export an SSIS project in SSMS to an ispac

    dndaughtery wrote:

    I think its on my side. My SSMS crashes and restarts. As of now we dont have src control where im at. We're in the process of setting it...

    July 20, 2020 at 3:02 pm

    #3771370

    • Viewing 15 posts - 2,521 through 2,535 (of 13,877 total)