Search results for query: *

Got this now. Thanks for your help. For reference, here is the code I am using: select s.ProductID,(select top 1 CustomerID from Order where ProductID = s.ProductID group by CustomerID order by sum(Quantity) desc) CustomerID from Stock s

I am trying to write a query that returns the customer who has bought the most of a product. I have an Order table with CustomerID, ProductID and QtySold (amongst other things, obviously!!). If I do: select CustomerID,ProductID,sum(QtySold) SumQtySold into #Temp from orders group by...

Has anyone tried using Crystal Reports 9 with a Blackberry handheld? If so, how did you do it and what was the level of success. There seems to be very little documentation out there on this Thanks Alex

I had this problem. Uninstalling and re-installing the BES to version 3.6SP1a fixed the problem (I had to have the full version sent to me on CD as it is not available for download). Crude but effective!!

Have a look at DataRocket from ESB Technologies - http://www.datarocket.co.uk I have had this demo'd and it look really good. Not actually using it in anger at the moment

Anyone got any views as to how to effectively document OLAP cubes?

Found this one. I am running SQL7 SP3 and OLAP SP3 I was using the OLAP services Add-in to schedule the jobs. If you save the jobs as 'SQL 2000 encryption', they hang. If you take this off, they work. Cheers Alex

I am processing 5 cubes through a DTS job. Three of the cubes process fine and then the job hangs on the fourth Any clues? Cheers Alex