And here another solution, using REVERSE and SUBSTRING you mentione as problematic (solution with Numbers table is probably more efficient and I'd go for it, if it is possible)

declare @text varchar(1024),...

Hello Mario (or Morten?),

Unfortunately I don't understand what precisely the procedure should do and what is wrong with the result. PLease try to be more explicit about the desired result...

OK, I'm not that experienced in HTML so I better supposed that such possibility (< or > inside the text) exists. If that does not happen, everything is fine. I...

Jesper and Rob,

I didn't study the SQL provided in your posts, but it seems very similar to the code I wrote this morning when I first saw this question. However, I...

The word INNER is recommended but not obligatory, as far as I know. Unless specified otherwise, a JOIN is considered to be INNER.

I don't see any reason why you should not use standard join (the first version), or how using a derived table could improve performance. Preferable because of simplicity and readability...

Oops... thanks for catching the error with alias, Sergiy. I concentrated on the conditions too much and overlooked that, just copied it from the original post.

In short, Trigger, if you...

Although it is best practice to name columns, and especially in such article it would be advisable to do it correctly, it is not true that the insert will not...

IMHO the problem is not in the ISNULL or EndDate (at least not in the example you described). It is the time portion.

A.ClaimDte >= L.StartDate is not true in your...

Well, I suppose that the rows are not updated, because the conditions don't include them in the resultset. Without precise information about at least one row that is not updated...

Probably you didn't take out the GO commands... CREATE PROCEDURE statement ends as soon as it reaches the first GO, everything following it will not be included in the proc...

Hello Chad,

did you try the code I posted? I think it should work fine, no matter whether you are using GUID or autonumber as ID. It simply makes JOIN on...

OK, about the loop... you have to define start and end, and a way to loop (increase some counter). I can hardly give you a working SQL without knowing your...

Just out of curiosity, if you edit the original function and enclose the "INSERT @BusinessRoles SELECT @BusinessRoleId" in a BEGIN - END block, will the problem persist or not? I've...

You need a loop of a kind, yes. It can be done with a function though, cursor is not necessary. Is this what you were looking for?

--testing environment

--TableOne - Only...