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.

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...

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...

• This reply was modified 4 years, 12 months ago by  Alan Burstein.

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...

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 5 years ago by  Alan Burstein.

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...

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...

I do not understand the benefit of using a 'cross join' versus an 'inner join' on the sql above pointing to the same table?

There is no "benefit", it's a design...

This is good information.  My question now is, why even use a UDF as a source for a report?  Why not just have the report user access a view...

First, as a general rule: when considering user defined functions (UDFs) the most important thing is if the function is inline or not. If performance is important, the only viable...

Good one Steve!

a great start - I use rownumber over (partition by order by) a lot

one of the more overlooked windowing fuctions though is NTILE - especially when you are dealing...

Absolutely brilliant! I love this article. Well done. Five stars.

You would probably want to create a calendar table when you also want to exclude bank and national holidays since those can vary by country, company and...

That function looks like a horror movie and it's not even Halloween yet.  The function below, ifn_workdays, is what you need. It does not handle holidays. Here's an example and...

• This reply was modified 5 years, 1 month ago by  Alan Burstein.
• This reply was modified 5 years, 1 month ago by  Alan Burstein.