Viewing 15 posts - 316 through 330 (of 374 total)
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 ',...
January 19, 2006 at 1:48 pm
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...
January 19, 2006 at 1:40 pm
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)
January 19, 2006 at 12:59 pm
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...
January 19, 2006 at 12:48 pm
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...
January 19, 2006 at 10:47 am
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...
January 19, 2006 at 10:37 am
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...
January 19, 2006 at 9:54 am
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...
January 19, 2006 at 8:59 am
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...
January 19, 2006 at 8:50 am
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...
January 18, 2006 at 10:31 am
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...
January 18, 2006 at 9:32 am
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....
January 18, 2006 at 8:42 am
>>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
January 16, 2006 at 7:29 am
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...
January 16, 2006 at 7:05 am
Viewing 15 posts - 316 through 330 (of 374 total)