webtekkie (10/30/2012)

---

I hate to throw cold water all over your efforts Dwain, but it appears the output does have to be an int and not a decimal. I think...

Jeff Moden (10/30/2012)

---

dwain.c (10/29/2012)

---

Sorry about that! ...

And here is my version:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[f_JoinToOne]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))

DROP FUNCTION [dbo].[f_JoinToOne]

GO

CREATE...

Sean Lange (10/29/2012)

---

Jeff Moden (10/27/2012)

---

I wonder how many 3 and 4 letter swear words such a proccess will actually spell out.

I strongly recommend not using incrementing alpha-numerics for just such...

Could you answer the questions I've asked?

What is the maximum size of Value1 and datatype of Value2?

There is only one method to get alpha-numeric sequence into decimal - it's...

I don't have SSIS available right now to write a statement, but you should be able to derive it from this T-SQL example:

declare @v-2 varchar(1000)

set @v-2 = 'TH*4.2*857463*01**20091015*1045*P**~~IS*7564* PHARMACY~PHA*1234567890~PAT*MA*06*987544****SMITH*JOHN****1234 MAIN...

Because

returns position of the first occurance of "PAT" in your [Column 0], which is for the given sample string is 71.

and

returns position of the first...

Decoding values such as '544DX88DGT' (and let say...

The issue is reported to you: 'Dave Smith' cannot be...

Jeff Moden (10/27/2012)

---

luissantos (10/26/2012)

---

Hello Eugene

I will test your script for only for one REF(Article) = '2019023'. this article have only one invoice with one line.

Your script :

UPDATE fi

SET cor...

Actually it depends how you take it, at least some of them...

luissantos (10/26/2012)

---

Hello again

I test the statment with the WHILE from yeshupandit_2002 and i have adding a condition for ref like '2%', i talk about 8323 REF (article) with 315610 records...

Are you a gambler?

:hehe:

The only thing I would suggest is to include updatable table under FROM clause, to avoid possibility of SQL Server building Cartesian...

If you want your CLR with Regex to perform well you need to declare your Regex object as static and use Compile...