Phil, i have edited my code, please use the latest code. Sorry for...

skcadavre (6/7/2010)

---

ColdCoffee (6/7/2010)

---

If your request is what Sckadavre is saying, then this might help you! This code doesn use a self-referencing CTE, but assuming your string contains only one Key1:...

Yes it will be.. but if u be bit more specific on what you need, then v might provide a better solution..

Kavya,, try this:

create procedure USP_InsertStatusText(@Statustext char(150),@RecievedBy varchar(50),@Deliverydate datetime)

as

BEGIN

declare @date datetime

set @Deliverydate= convert(varchar,@Deliverydate,1) --as [mm/dd/yy] from TB_StatusEntry

insert into TB_StatusText values(@Statustext,@RecievedBy,@Deliverydate)

END

But i tell, you, please store the date field in...

If your request is what Sckadavre is saying, then this might help you! This code doesn use a self-referencing CTE, but assuming your string contains only one Key1: "

DECLARE @DELIMITER...

If thats NOT what you wanted, then please tel us your desired result based on the input recored set i provided..

Broadening the input result set:

Sample table and sample data

DECLARE @table TABLE ( STRING VARCHAR(64) )

INSERT INTO @table

SELECT '7487-OEM-00011193-0010(Key: HHYUR-86HZH-99V96-JKL0-88895)'

UNION ALL...

Hey Phil, is this what you are looking for?

DECLARE @str VARCHAR(64)

SET @str = '7487-OEM-00011193-0010(Key: HHYUR-86HZH-99V96-JKL0-88895)'

SELECT SUBSTRING(@str,( CHARINDEX('Key:',@str)+5 ) , (CHARINDEX ('-',@str,CHARINDEX('Key:',@str)) - (CHARINDEX('Key:',@str)+5 ) ) ) KEY_FIRST_PART

Taking...

Initially, the OP said it is 60 days, but if u could see the quote i my previous post, the...

hey there, this might help you.

First lets set-up sample data and table

DECLARE @TABLE TABLE (STRING VARCHAR(100))

INSERT INTO @TABLE (STRING)

SELECT 'E01234/1-1'...

Dehqon, from this requirement, i see that you are interested in the same day of the...

Luca, why not break the 187998 rows into chunks of say 10000 and then carry out your processing ?? AS u have rightly said, CURSORs are troublesome, try using set-based...

Wow, such a nice feeling...

Ray K, nice that you have fixed the code, but for soehting called SQL Injection, you will still need to tweak the code a bit.. Please go through these following...