Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by DCount

  1. DCount

    Create Analysis Server role using DSO in C#

    I'm using VS2005. Any example of how to use DSO to create a database role in Analysis Services? I've added a DSO.dll, but still receive a compile error. Using DSO; Server dsoServer = new DSO.ServerClass(); dsoServer.Connect("123.45.6.789"); MDStore dsoDatabase =...
  2. DCount

    Can a query be run on separate tables in RS

    I have a very complex query that needs to return monthly and year-to-date data. I'm using one table (table A) to correctly return the monthly data. I would now like to create another table and use a result from table A to correctly filter and display the year-to-date data along side the monthly...
  3. DCount

    Complex query to limit results based date in same table

    After reading more about joins, I tried this query, but received errors near the WHERE (d.YEAR = '2005') clause. Thanks SELECT a.LDGACT, a.ACCTNAME, SUM(f.REVENUE) AS REVENUE FROM FORD.dbo.DATA f JOIN FORD.dbo.ACCOUNT a on f.idACCOUNT = a.idACCOUNT JOIN FORD.dbo.DATE d on f.PUBDATE =...
  4. DCount

    Complex query to limit results based date in same table

    Not being good with complex sql statements, I'm looking for help with the following: I need to create a report that will display revenue data for accounts that DO NOT have revenue for the previous year. The following query doesn't work. SELECT DISTINCT a.LDGACT, a.ACCTNAME, SUM(f.REVENUE) AS...
See more

Part and Inventory Search

Back
Top