Forum Replies Created

Viewing 15 posts - 1 through 15 (of 2,434 total)

  • Reply To: Longest Common Substring in an ITVF

    Jeff Moden wrote:

    I'm not seeing any code attached to your last post.  What code are you talking about being "attached"?

    x

     

     

     

     

     

     

     

    Grrr...

    /*********************************** PART #1...
  • Reply To: Longest Common Substring in an ITVF

    UPDATED 20200803 at 9:30PM

    Ok, 4 1/2 years later I have a something really good to show!

    This code is from one of many articles in various phases of completion which I'll...

    • This reply was modified 2 months, 4 weeks ago by  Alan Burstein. Reason: Typo
    • This reply was modified 2 months, 4 weeks ago by  Alan Burstein.
    • This reply was modified 2 months, 4 weeks ago by  Alan Burstein. Reason: Trying to add files
    • This reply was modified 2 months, 3 weeks ago by  Alan Burstein.
  • Reply To: The Computing Revolution

    Great article Steve. Really informative.

  • Reply To: Regex Help

    I've just added CLR Regex Functions to our SQL Servers.

    I'm trying to replace some of our less efficient string parsing TSQL functions with the new .Net CLR Regex Functions.

    For things...

  • Reply To: Are the posted questions getting worse?

    If anyone is interested in a rather interesting problem has a look at this: https://www.sqlservercentral.com/forums/topic/table-function-returns-varying-number-of-records-for-an-update-statement

    I gave up.

  • Reply To: Table Function returns varying number of records for an update statement

    I'm really curios to what is happening internally for the varying set of records that get updated.

    This is one of the more interesting problems I've seen in a while on...

  • Reply To: Table Function returns varying number of records for an update statement

    To  quote Ned Flanders, "Wow! As melon scratchers go, that's a honey doodle."

    I can confirm that I see the same issue and racked my brain trying to figure out how...

  • Reply To: Extract Blocks of Number

    Jonathan AC Roberts wrote:

    Alan Burstein wrote:

    Grab a copy of NGrams8k and you can do this:

    Declare @Temp Table(SomeId INT IDENTITY, [Data] VarChar(8000))

    Insert @Temp ([Data])
    Values('hello my name is john 07999999999 smith 07888888888...
  • Reply To: Extract Blocks of Number

    Grab a copy of NGrams8k and you can do this:

    Declare @Temp Table(SomeId INT IDENTITY, [Data] VarChar(8000))

    Insert @Temp ([Data])
    Values('hello my name is john 07999999999 smith 07888888888 this last...

    • This reply was modified 11 months, 1 week ago by  Alan Burstein.
  • Reply To: Understanding Outer Joins in SQL

     

    This is an inner join, and is an intersection of the data in the tables. This is shown in the image below.

    Careful here. An Inner Join and an Intersection are...

  • Reply To: SELECT processed before WHERE clause

    The order of processing is as follows:

    FROM

    WHERE

    GROUP BY

    HAVING

    SELECT

    ORDER BY

    LIMIT

    LIMIT is MySQL not SQL Server. The last three things to be processed are : SELECT then TOP / OFFSET then ORDER...

  • Viewing 15 posts - 1 through 15 (of 2,434 total)