Forum Replies Created

Viewing 13 posts - 1 through 13 (of 13 total)

  • RE: Running totals... in groups

    okkko (8/26/2010)

    skcadavre (8/26/2010)

    gah (8/25/2010)

    I realise that you have probably only given us some sample data....but is there any chance that you have a unique row identifier in your real data

    Yeah,...

    August 27, 2010 at 6:51 am

    #1212891

  • RE: Running totals... in groups

    skcadavre (8/26/2010)

    gah (8/25/2010)

    I realise that you have probably only given us some sample data....but is there any chance that you have a unique row identifier in your real data

    Yeah, agreed....

    August 26, 2010 at 2:02 am

    #1212120

  • RE: Running totals... in groups

    gah (8/25/2010)

    Correct! Sorry for such a crappy presentation of the problem.. Am reading that "excellent article" ;).. I'm excited about the speed and the hacking spirit around it, but...

    August 25, 2010 at 8:13 am

    #1211658

  • RE: Running totals... in groups

    skcadavre (8/25/2010)

    okkko (8/25/2010)

    skcadavre (8/25/2010)

    That's a bit better 🙂

    OK, what do "movings" and "stock" represent? Is movings the sum of the "quant" per day for each brand/outlet? Then stock the running...

    August 25, 2010 at 8:08 am

    #1211654

  • RE: Running totals... in groups

    skcadavre (8/25/2010)

    That's a bit better 🙂

    OK, what do "movings" and "stock" represent? Is movings the sum of the "quant" per day for each brand/outlet? Then stock the running total of...

    August 25, 2010 at 3:38 am

    #1211512

  • RE: Use of identity columns in foreign key references

    Grant Fritchey (6/13/2008)

    Purist anything in databases is usually a sign for disaster. There are places where an identity column as a PK and as FK's in all the related tables...

    June 13, 2008 at 7:00 am

    #828445

  • RE: Bad Microsoft DB Schema Example

    It seems that some of you have missed my link:

    source page

    June 12, 2008 at 11:38 am

    #828021

  • RE: Bad Microsoft DB Schema Example

    Christopher Stobbs (6/12/2008)

    WEll you need to remember that you shouldn't use SELECT * so you should return the book columns in a food query

    Hehe, yes of course. 😀 How would...

    June 12, 2008 at 8:53 am

    #827920

  • RE: Bad Microsoft DB Schema Example

    Lynn Pettis (6/12/2008)

    Not knowing the full details of the example it is difficult to make a judgement. One thing to remember is that while designing a database for a...

    June 12, 2008 at 8:45 am

    #827911

  • RE: Updating DB with new SPs & data?

    Ugh, oh.. I thought it would be easier (guys (and any potential gal), still time to chime in :D)

    rbarryyoung, your version sounds the most logical to me. Just curious, why...

    June 8, 2008 at 3:28 pm

    #825916

  • RE: Logging stored procedures execution and/or modification?

    I ended up using Jack's code. Just created my own table dbChanges and also added a datetime field. So the main thing now looks like this:

    INSERT INTO dbChanges

    ...

    June 6, 2008 at 4:37 am

    #825347

  • RE: Logging stored procedures execution and/or modification?

    Jack Corbett (6/4/2008)

    If you want to track changes to stored procedures you can create a DDL trigger for ALTER PROCEDURE, I assume you are on 2005 since this is a...

    June 5, 2008 at 7:29 am

    #824792

  • RE: Logging stored procedures execution and/or modification?

    Oh man, thanks for all the replies. I'm currently not at work but will look into your suggestions. Thanks every one!

    June 4, 2008 at 10:57 am

    #824345

Viewing 13 posts - 1 through 13 (of 13 total)