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

    February 6, 2015 at 7:43 am

    #1776044

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

    February 5, 2015 at 9:12 pm

    #1775942

  • 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(*)...

    February 5, 2015 at 9:06 pm

    #1775941

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

    February 5, 2015 at 1:29 pm

    #1775875

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

    February 5, 2015 at 12:20 pm

    #1775847

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

    February 5, 2015 at 10:58 am

    #1775804

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

    February 5, 2015 at 10:13 am

    #1775778

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

    February 5, 2015 at 8:19 am

    #1775718

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

    February 4, 2015 at 10:25 am

    #1775401

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

    February 4, 2015 at 9:33 am

    #1775379

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

    February 4, 2015 at 9:20 am

    #1775372

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

    February 4, 2015 at 9:18 am

    #1775371

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

    February 4, 2015 at 8:56 am

    #1775357

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

    February 4, 2015 at 8:54 am

    #1775356

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

    February 4, 2015 at 8:53 am

    #1775354

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