These are the records  I've in my table. I need to return top 3 countries (rank) by Sales.
Record            Date                Country                Sales
1                    01.01.04            AU                        80%
2                    01.01.04            IN            ...

I'm new to all the technologies above and so really need
some help as I am solely in charge of building a Warehouse
solution that uses all of the above!!
I have created a cube in OLAP that based on Usage

I have the "Order By" property set to "Name".  By default this is in
ascending order.  But I need to sort in descending order.  How can I change
this?
Thanks

Can anyone put some light on the various ways of storing
large numbers of a imges into a huge relational database
table. I would be thankfull if i could know the most
effective way of doing it without slowing down the server

I have a database with 1 table and 4 fields. No relational link with
anything or other databases. I add about 20 records per second and
periodically query for information. My question, should I create an index
for this table? If so why? If so why? I thought a index would make sense ...

I have a colume assigned to datetime format, where the value is say
"06:31:31" rather than 20/05/2004 06:31:31. When I retrieve the value from
the table, the result were 30/12/1899 06:31:31. Is there a way to change the
format so that I only need to put the time variable into the ...

for Analysis Services 2000 the dimension members for a parent is limited to
64.000 members.
Does anybody know what the limit for Yukon is?
Michael

I understand the very basics of MDX. I know how to, for example, get
some set of measures as columns with some dimension on the Rows.
However, I need to do something more complex and I just can't get my
head around it.

Please help - I'm quite new to this game!
I am trying to copy data from a database on one site (live database) to a
database on another site (data warehouse) - obviously the size of my tables
is growing all the time, as is the amount of databases i'm transferring

I am tring to write a query to show the Max value of
several columns.  I would like to store that value in a
new column.  Please help I can not write this.
Duvon Harper

I have table with all customers transactions
I am trying to create a query that can show me the balance of our customers.
I am trying to see when customer had the highest balance. How can I do this?
My customers transactions

This is a very long shot. I'm not an sql expert by any means but I have a question that I've been told to ask - someone may be able to answer, even if the answer is "no".
A sql table has been emptied of all rows. There is no backup of the .mdf prior to this happening. No ...

After scheduling a dts, which retrieves data  from a priority-tabula server
(using the tabula propriatary odbc driver) , no rows are transfared.
There is no error massage i can trace sql server or in any of its logs, the
job just passes gracefully by the dts data transfare tasks, ...

Can anyone table if table size can be increased?  If so how?
Any help would be greatly appreciated.
Thanks in Advance.
SqLRattler

Hi every body
I'm thinking of using sql server profiler and/or the windows performance
logs (with sql server  objects counters), to trace a problematic job which
fails to retrieve any rows by executing a dts (wich inbcludes  transfare