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 dataYeah,...
-
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 dataYeah, agreed....
-
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...
-
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...
-
RE: Running totals... in groups
skcadavre (8/25/2010)
That's a bit betterOK, 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...
-
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... -
RE: Bad Microsoft DB Schema Example
It seems that some of you have missed my link:
-
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 queryHehe, yes of course.
How would... -
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... -
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...
-
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
...
-
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... -
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!
Viewing 13 posts - 1 through 13 (of 13 total)