This article[/url] describes a CLR function to calculate the Levenshtein-Distance. Implementing the full functionality in an iTVF is tricky and results in poor performance. Here's an iTVF which is almost...

Sean Redmond (8/30/2016)

---

It seems to me as if the modern development method is the problem.

Get your user-stories implemented as soon as possible.

The database is «persistence layer». It might as well...

Beatrix Kiddo (8/26/2016)

---

Shame on you, Chris ;-). No chopsticks in Thailand for one thing.

Following those directions on Google maps, it shows a place claiming to be a chinese &...

Luis Cazares (8/26/2016)

---

Beatrix Kiddo (8/26/2016)

---

Go to Canal street. Face east. Turn right on Mott. Go down a block. Turn right. Thai restaurant...

"First, a row is processed in the outer doubt" :w00t:

Sergiy (8/25/2016)

---

ChrisM@Work (8/25/2016)

---

Of course not. The function calculates US holidays because most users of ssc are in or from the US. I'm in the UK and I've written a similar...

Sergiy (8/24/2016)

---

ChrisM@Work (8/24/2016)

---

paulo.margarido (8/24/2016)

---

i'm aware of what "inline table-valued functions" are, i have a few of my own in the DB

what i ask is how can i do it that...

paulo.margarido (8/24/2016)

---

some sample return data:

FuncaoResultdate

------------------------------------------------------------------------------------------------------------------------------------------

DATEADD(d, 39, dbo.fncDiaPascoa(@Year))2016-05-05 00:00:00.000

dbo.fncProcurarData(DATEADD(D, 0,DATEADD(M, 9, DATEADD(YY, @Year-YEAR(0), 0))), 1, 7, 2 )2016-10-03 00:00:00.000

dbo.fncCalcularData(DATEADD(D, 0,DATEADD(M, 7, DATEADD(YY, @Year-YEAR(0), 0))), 2, 4)2016-08-29 00:00:00.000

fncDiaPascoa() gives easter day for...

paulo.margarido (8/24/2016)

---

i'm aware of what "inline table-valued functions" are, i have a few of my own in the DB

what i ask is how can i do it that way

if you...

paulo.margarido (8/24/2016)

---

Thanks for the response

There are not big performance issues, the table has only 400 rows

but is for the sake of making it better, and learn something with it

what do...

Hats off to you for recognising that this solution can be improved and seeking advice.

Most folks would recommend a table holding the dates and districts, but calculating the holidays...

david.earl (8/24/2016)

---

Hi,

The results of your test show exactly what I was getting at. The final result shows 0 while the logic suggests it should be 1.

essentially if its >= 0.5...

WhiteLotus (8/23/2016)

---

Thanks for the feedback mate

No index in table at all ( I click on index folder and nothing comes out )

Actually this is deadlock case as there are...

Sure no problem.

Can you set up your...

'Zackly. By the time you've finished reading it...