Forum Replies Created

Viewing 15 posts - 2,521 through 2,535 (of 13,874 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

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

    Also, can't you just regenerate the ispac from source control?

    July 20, 2020 at 2:49 pm

    #3771364

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

    Can you tell whether the error is generated locally, or on the server?

    July 20, 2020 at 2:48 pm

    #3771363

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

    Leena Chittivelu wrote:

    I have a simple way to remove multiple commas in the whole string.Here is the simple one to suffice all the below cases:

    1> Removing multiple commas in starting of...

    July 20, 2020 at 2:44 pm

    #3771362

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