Hi

When your refer to 'cube' are you...

In SSMS

Tools>Options>Query Execution>SQL Server>Advanced

there are check boxes here for SET STATS....are they on or off?

(3630 row(s) affected)

Table 'HOURLY_STATS'. Scan count 3, logical reads 27408, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server...

I tell them that I work in the circus...

...remember the elephant in the ring

...remember the guy walking behind the elephant

... thats me ..with the scoop....:-D

clubbavich (9/3/2011)

---

I haven't even attempted it. To do so would be to execute 3600 select statements connected by UNION ALL. I cannot imagine that that would do anything good for...

what sort of times are you currently returning...

Lutz ...thanks for the good wishes….. time will tell whether my views on such a project ever see the light of day 🙂

Project management / managing expectations / business...

Have a search on this site for "Audit", "Slowly Changing Dimensions (SCD)" etc,

there are many articles, thoughts and code....hopefully this will give you a start.

For example: Old Phone #...

Thanks Lutz

Ask the end users if they can do their daily business just with the system or if they're running multiple ACCESS and/or EXCEL solutions aside just because the system...

nearly 600K views on "The Thread"

:w00t::w00t::w00t:

gcresse (9/1/2011)

---

The spreadsheet calculations are correct. I forgot to mention in my original post that the product is liquid and stored in a tank. As new receipts come...

quick google found this...any good?

http://www.dbforums.com/microsoft-access/987393-decode-equivalent-ms-access.html

you may also find this useful:

http://eis.bris.ac.uk/~ccmjs/ora_sql.htm

sorry if no good...I know nothing of Oracle 🙂

how many tables, how many rows and how many rows have been changed since last load?

SELECT b.*

FROM (SELECT accredappid,

question,

...

Hi

based on the sample code you gave, for the shipment on 2011-01-04 of qty 100 of product 123.....how do we know which receipt this was taken from?