Of course I made some assumptions on the data. I could not come up with anything that ends in PT and you put in the ice cream.

SELECT CHARINDEX('PT ', @Msg) -- this gets you the position of the PT

SELECT SUBSTRING(@Msg, 0, CHARINDEX('PT ',...

This is strange. I just copied and pasted the code from the post into the query analyzer and it run fine. If you have trouble getting it I can break...

Try this :

DECLARE @Msg VARCHAR(200)

SET @Msg = 'GODIVA ICE CREAM PECAN CARAMEL TRUFLE REGULAR 0.7813PT 4154825833'

SELECT RIGHT(SUBSTRING(@Msg, 0, CHARINDEX('PT ', @Msg)), CHARINDEX(' ',REVERSE(SUBSTRING(@Msg, 0, CHARINDEX('PT ', @Msg)))) -1)

I don't think this is performance related. Looks like some kind of timeout on a page or cookie or stuff like this.

It is frustrating because sometimes I just don't...

This one way of doing it:

CREATE TABLE test

(

OrderNo CHAR(1),

Line INT,

Qty   INT,

Total int

)

GO

INSERT INTO test ( OrderNo, Line, Qty) VALUES ('a', 1, 2)

INSERT INTO test ( OrderNo, Line, Qty) VALUES ('a', 2, 5)

INSERT...

I think that if the CustomerID is unique within CompanyID you could use the two as your key. If you have to throw in the CustomerName into the mix I...

I hope I was not offensive with my last post. If I were, I appologize. Not blaming anyone, just want to make sure the issue is looked into. Looks like...

Yep, it is not funny. And what happens sometimes I just give up and don't waste my time trying to recreate the message.

I looked at the threads you listed...

This is not really that complicated. No one is allowed to make database structure changes on their own. We got a process in place that takes care of this.

We...

This is what I always promise myself when it bums on me. But then I forget and it happens again. Plus, I have no clue, how long before the timeout kicks...

This is the problem. They write the code and when they script their settings at the time of creation are reflected in the SP script ( the SET options are...

I typed a long reply and the whole went blank on me when I posted so I have to give a short explanation. We got mulitple people working on the development....

>>I don't even know if this can be done

Everything can be done. It is just matter of time and money. - this is what my ex-boss used to say

If the dates are predefined and there is REALLY no formula then one of your options is to create a new table with

MonthCode - this is where your 05-10 will go

StartDate...