Here's an option using an inline table-valued function which would perform a lot better than a normal function. It also has a test to show how does it work.

The code...

fabriziodb (12/2/2016)

---

CELKO (11/30/2016)

---

>> I need a query to find out all orphans over a hierarchical table <<

``

I never heard this term before, and I wrote the standards. I think you...

SQLsharp has a validation for credit cards. It will only validate a number and won't extract it from a string. If you want to try it, feel free to do...

I'm sorry, I...

Lynn Pettis (12/1/2016)

---

For someone who has been "around" SSC as long as "he" has, he sure hasn't changed in all these years.

I stayed away and thinking I will bypass him...

You could have also changed it like this and keep it as a function with zero reads.

CREATE FUNCTION [dbo].[PatternSplitCM](@List [varchar](8000) = NULL, @Pattern [varchar](50))

RETURNS TABLE WITH SCHEMABINDING

AS

RETURN

...

whenriksen (12/1/2016)

---

Another option:

SELECT @Dummy = CASE WHEN LEN( Med_Rec_Nbr ) < 7

THEN...

How can you differentiate it from the visa card that has the expiration date together?

Here's another option that works with your sample data. The function is posted and explained in...

This might give invalid card numbers, but it's worth a try.

WITH ctePatterns AS(

SELECT *

FROM (VALUES

( '%[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]%', 16)

,(...

You should also read this article to avoid looping in SQL.

http://dwaincsql.com/2014/03/27/tally-tables-in-t-sql/

It's also slower. It's...

It's not a random function, but it creates a random value which is designed to be a...

Kill all connections. 😀

To download 115MB in 200 seconds is the same that downloading 117,760KB in 200 seconds. If you divide the number of KB by the seconds, you'll get the KBs needed...

I'm sure that you've been guided to this article before, but this is an example...