Viewing 15 posts - 2,221 through 2,235 (of 2,452 total)
Hi
Please see below more info about the data and schema. The data I'm using has been extracted from a cube into a text file
When your refer to 'cube' are you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 4, 2011 at 6:05 am
In SSMS
Tools>Options>Query Execution>SQL Server>Advanced
there are check boxes here for SET STATS....are they on or off?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 4, 2011 at 1:36 am
(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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 3, 2011 at 11:17 pm
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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 3, 2011 at 1:59 pm
clubbavich (9/3/2011)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 3, 2011 at 11:49 am
However, what If I wanted the latest Data_Timestamp value for each device on each server? This approach does not scale well at all.
what sort of times are you currently returning...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 3, 2011 at 10:32 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 2, 2011 at 2:10 pm
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 #...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 2, 2011 at 12:40 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 2, 2011 at 12:34 pm
nearly 600K views on "The Thread"
:w00t::w00t::w00t:
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 2, 2011 at 11:06 am
gcresse (9/1/2011)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 1, 2011 at 4:04 pm
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 🙂
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 1, 2011 at 7:01 am
how many tables, how many rows and how many rows have been changed since last load?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 1, 2011 at 3:49 am
SELECT b.*
FROM (SELECT accredappid,
question,
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 1, 2011 at 3:24 am
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?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 1, 2011 at 1:31 am
Viewing 15 posts - 2,221 through 2,235 (of 2,452 total)