In my experience with Power Pivot this error usually occurs when you pc memory isn't sufficient to refresh all the tables at once. I haven't found a way around...

This is a pretty good book with all the basics.

http://www.marktab.net/datamining/index.php/2010/11/05/data-mining-for-business-intelligence-book-review/

Also, for SQL specific Data Mining for SQL Server 2005 (although I believe that the 2008 edition is out)....

It sounds like the OP is using Access to generate the reports not MYSQL. Access won't let you do multiple unions.

Power Pivot is an Excel add-in. It does not require SQL or Sharepoint to deploy. It can connect to any datasource.

Bruce,

Thanks for the information. I know what is causing the problem - it's a many to many relationship so the subquery returns more than one row. I think...

Paul,

Thanks for the correction. I have never had to write a cursor so was hoping my assumption was incorrect.

Thanks,

Sue B

Lowell,

Thanks for the info. I'll download it and see if I can connect to our Oracle db. From what I've read, once I set the subquery to return a...

Thanks for the information guys. I don't have access to the SQL Developer tool. I use SSMS and T-SQL so am having are hard time tyring to help...

Lowell,

Thanks for the quick response. Just to make sure I understand, the rownumber=1 would go in the where clause like so

UPDATE CLEAN_DATA_0500 CLN

SET CLN.HIST_INSTANCE (

SELECT HIT.HIST_INSTANCE

FROM HIST_INSTANCE_TBL HIT

WHERE CLN.MIN_SERVICE_FROM_DATE...

If you have Office 2010 there is a free add-in from Excel called PowerPivot. Just go to the MS site and search for the download. What it does...

hbanerje (4/25/2011)

---

select id,

idnum,

max(dischargedate) as...

Lutz,

Thanks so much. I just couldn't figure out how to get the line numbers to go with the fields. I don't have any control over the table schema...

Thanks for the suggestion Brandie. However, doesn't pivot require you to do some sort of aggregation ? My problem doesn't require any aggregaton which is why I was...

In our area (Charleston, SC), the local Goodwill accepts all outcast pc's and associated hardware (make sure to erase everything first !). What can be refurbished, they use as...