Hi All, 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 ...more >>

Hello 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 Imrahn ...more >>

Hello, Im a member of a team planning a data warehousing project. We have multiple data sources which are aggregated in a staging area. This is then denormalised and imported into the datawarehouse database. I am looking at ideas for incremental data refresh, rather than a drop and re-import o...more >>

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 as well as its resources....more >>

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 if it was rel...more >>

Hello all 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 statistics of our website; so each UserName is assigned to a CompanyID, ...more >>

Hi, I want to know what is the rule behind the score calculated value in the scorecard accelerator application. I've a satisfaction value (which is a %) of 80%; my target is 85% Score = 75%???? any idea? thanks, Jerome. ...more >>

Hi, 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 ...more >>

Hi. 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 from. What I want to...more >>

I want to create a new calculated member in a virtul cube. I have a dimension Time with 3 levels Year Month and Day and a Measure ValSal. I want to get a value from the measure ValSal on day 2004/05/25, but i don't know how? With this value i want to fill the calculated member. ...more >>

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. What I'm trying to do is compare some given measure for various periods....more >>

Hello there, my datawarehouse uses SQL 2000 enterprise as database. When the ETL process runs it takes all the memory of my server (aprox 2gb) and when it finish, the memory stay freeze, an the task manager shows that the MSSQL still using the memory and this takes a long time, so I have t...more >>

Hello, 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 Kaiser Permanente...more >>

Hi 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 Record number Date. Customer ...more >>

Hello, Can anyone table if table size can be increased? If so how? Any help would be greatly appreciated. Thanks in Advance. SqLRattler --- Posted using Wimdows.net NntpNews Component - Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Rati...more >>

Hi, 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 transaction loggin...more >>

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 data tasks). The dts works just fine by it self. When sched...more >>

Hi all 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, which al...more >>

I'm programming a report with reporting services accessin to a OLAP database. Analysis Services and Reporting Server are installed on a Windows 2003 Server When I show the report with the preview option it works fine. The data is showed correctly. But when I try to execute the report it shows me a...more >>

Hi, We currently have 6 fairly large fact tables (10 to 30 millions rows per table). They become complex to manoeuver for OLTP and DB maintenance tasks (too execution time). We are considering splitting these fact tables by smaller ones, based on month. And then source the cubes from the...more >>

Hi, I've to recommend a new server for a datawarehouse server which contain some data warehouse databases (5 databases of 5Gb each) I plan 6gb of memory and some SCSI drives (5 * 18 gb in raid 5 + 2 * 18 gb in raid 0 for the tempdb) there is 200 users for the system for the moment (not co...more >>

I cant wait for Microsoft to put these idiots out of business so i can stop working on the crap ...more >>

Is it possible to transpose data from a table? I have data in the format shown below Date Hour Price 5/21/04 1 5 5/21/04 2 7 5/21/04 3 9 5/21/04 4 12 Is it possible to have the data print out in this format? 5/21/04 5 7 9 12 I ...more >>