Hello friends, I'm sorry I have been off, thanks a lot Selburg, to you and Ninja's who was also in touch with tech approaches.

Yes Selburg, your solution works pretty good,...

The Business goal as stated at the beginning is for a huge list of codes to be able to print them in columns, to save paper, to build cheklists, just...

Look friends, I'm sorry if someone felt wrong it was just in save of time and richness of knowledge.

I'll be shorter, what I say, forum is not to post too...

Estimated friends, I appreciate your concern, but trust me best practice to help in the forum is do not issue banal views when the answer is not known. I do...

Last Release, tested for new cases, see data.

Requires implementation of function: dbo.IsInteger(ID)

Regards!

DECLARE @Products TABLE(ID VARCHAR(20) NOT NULL PRIMARY KEY)

INSERT INTO @Products(ID)

SELECT 'SCREWDRIVER' UNION ALL

SELECT '224537' UNION ALL

SELECT '224538' UNION...

Good morning Mark, it's DONE!!!.. I'm actually glad! if sometime you need a team, count on me! Please test it when you get some time:

DECLARE @Products TABLE(ID VARCHAR(20) NOT NULL...

I added a little modification, I eliminated last '%' to indicate I just care final numbers, this works, but it splits groups and create some mess:

DECLARE @Products TABLE(ID VARCHAR(20)...

Thanks a lot Mark! It works great.

Althought I found out two issues.

First is related to Data:

There are a lot of Alphanumeric PK which are continuous, I'm sorry I did not...

I have been trying to apply the same solution as recommended in the msdn article:

http://social.msdn.microsoft.com/Forums/en-CA/transactsql/thread/c097ff31-aa01-4d7f-a1c4-63d3738ed147

In order to work with alphanumeric islands within a single column, to be able...

Thank you very much SQL Pirate for your response, it's exactly what I was looking for. I'm sorry previous explanation probably was not that clear to all, but Data was...

Actually this is an interesting topic, but I would advice using SqlBulkCopy instead, which provide amazing performance, with just a few lines of code:

public virtual bool SqlBulkCopy(DataSet ds, string TableName)...

It's actually cool. Thanks a lot. Have you test it for large tables, with joins?

I have recently checked it uses to be faster sometimes to create the temporal table...

Its interesting your article, one thing its not clear enought to me is why do you open your article with a GROUP and COUNT issue but later you develop a...