Forum Replies Created

Viewing 15 posts - 3,301 through 3,315 (of 15,381 total)

  • RE: Performance of the SQL MERGE vs. INSERT/UPDATE

    tmitchelar (10/29/2013)


    guy.stephens (10/27/2013)


    Much as we love the Merge statement in my workplace, we seem to be running into deadlocking problems that we haven't had when using the UPDATE/INSERT .. LEFT...

  • RE: FEFO query if condition

    136romy (2/5/2015)


    We can insert a new row with the same CODART 'M0001' but with a different CODMVT and NUMLOT. I make a stock management by batch number. the data that...

  • RE: Using a column name in a COUNT function

    SQLMaister (2/5/2015)


    There is nothing wrong with having *'s in your code. That is the most perfect SQL standard code as intended by the scientists who developed SQL. For example COUNT(*)...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (2/5/2015)


    So I just got a workplace reminder to wear red tomorrow because of National Red Day[/url].

    I didn't even know this was a thing, but it is. Wanna participate?

    My...

  • RE: FEFO query if condition

    yes When i insert a new row into FAIRE with a CODART of M0001 i want to update the existing rows

    What does that mean? I think the biggest challenge you...

  • RE: FEFO query if condition

    136romy (2/5/2015)


    yes I do exactly the insertion of 120 units (CODART) = 'M0001' (expiry date (DATPEREMP): 12/02/2012) in table "FAIRE"

    then I do the update of 80 units on the item...

  • RE: FEFO query if condition

    136romy (2/5/2015)


    hi sean lange,

    thank you for answered and thank you for the time you devoted to my problem.

    In fact what I have based on this data sample is:

    set up a...

  • RE: FEFO query if condition

    Let's start from a nice clean slate here since the ddl and sample data posts are all over board. I took the time to reorganize your script so it will...

  • RE: HOW TO ARCHIVE AND DELETE OLD RECORD IN A TABLE THAT HAS NO DATE COLUMN

    deebabat (2/4/2015)


    It worked. I was able to modify the script you provided for archiving also.

    Thanks for your help.

    You are welcome. Glad that worked for you and thanks for letting me...

  • RE: Are the posted questions getting worse?

    Sioban Krzywicki (2/4/2015)


    Sean Lange (2/4/2015)


    Sioban Krzywicki (2/4/2015)


    Sean Lange (2/4/2015)


    Sioban Krzywicki (2/4/2015)


    Grant Fritchey (2/4/2015)


    Eirikur Eiriksson (2/4/2015)


    Sioban Krzywicki (2/4/2015)


    Grant Fritchey (2/4/2015)


    Brandie Tarvin (2/4/2015)


    Anyone know anything about this Grant guy? Does he...

  • RE: Are the posted questions getting worse?

    Sioban Krzywicki (2/4/2015)


    Sean Lange (2/4/2015)


    Sioban Krzywicki (2/4/2015)


    Grant Fritchey (2/4/2015)


    Eirikur Eiriksson (2/4/2015)


    Sioban Krzywicki (2/4/2015)


    Grant Fritchey (2/4/2015)


    Brandie Tarvin (2/4/2015)


    Anyone know anything about this Grant guy? Does he know what he's talking...

  • RE: HOW TO ARCHIVE AND DELETE OLD RECORD IN A TABLE THAT HAS NO DATE COLUMN

    Not quite sure how you want to archive these but this should help with the delete. You can use a similar query for the archiving, but of course you should...

  • RE: Are the posted questions getting worse?

    Sioban Krzywicki (2/4/2015)


    Grant Fritchey (2/4/2015)


    Eirikur Eiriksson (2/4/2015)


    Sioban Krzywicki (2/4/2015)


    Grant Fritchey (2/4/2015)


    Brandie Tarvin (2/4/2015)


    Anyone know anything about this Grant guy? Does he know what he's talking about?

    Nah, I hear he's...

  • RE: HOW TO ARCHIVE AND DELETE OLD RECORD IN A TABLE THAT HAS NO DATE COLUMN

    deebabat (2/4/2015)


    What other detail do you want me to provide? I will provide.

    Since presumably you want help with the code we need to know what the table structures are. The...

  • RE: One table two rows

    djj (2/4/2015)


    Sean Lange (2/4/2015)


    djj (2/4/2015)


    So I guess my question is what is the proper way to join one table on itself to get data from two different rows then divide...

Viewing 15 posts - 3,301 through 3,315 (of 15,381 total)