Forum Replies Created

Viewing 15 posts - 316 through 330 (of 374 total)

  • RE: String Parse

    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 ',...

  • RE: String Parse

    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...

  • RE: String Parse

    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)

  • RE: Eliminate timeout when posting reply to a post

    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...

  • RE: Update Totals

    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...

  • RE: Redesign Help - Composite Keys

    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...

  • RE: Eliminate timeout when posting reply to a post

    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...

  • RE: Eliminate timeout when posting reply to a post

    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...

  • RE: How to script SPs in EM without SETs

    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...

  • RE: Eliminate timeout when posting reply to a post

    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...

  • RE: How to script SPs in EM without SETs

    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...

  • RE: How to script SPs in EM without SETs

    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....

  • RE: Triggers

    >>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

  • RE: Date three months ago (sort of...)

    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...

Viewing 15 posts - 316 through 330 (of 374 total)