Answer Questions

• 40th Floor Complicated query with really big tables

  Dear Experts, I want to write a very complex query on very huge tables. The scenario is the following: I have one table called #Products, one table called #Shops , one table called #Customers and one table called #CollectedInformation. #Products (ProductID int, ProductName varchar(10)) Product Information. Around 70,000 unique products #Shops(ShopID smallint, ShopName varchar(10)) Shop Information. Around 100 unique shops #Customers(CustomerID smallint, CustomerName varchar(10) Customer Information. Around 100 unique customers #CollectedInformation(ProductID int, ShopID smallint, CustomerID int, SalesValue money) Sales Information collected and inserted in a huge table. We don’t sell all products in all ...Show All

• sangminny can not deploy a report to ReportServer sub folders

  I am trying to deploy my report to somthing like https://SERVERNAME/ReportServer/BrianHome/ but i keep getting an error saying "A connection could not be made to the reportserver https://SERVERNAME/ReportServer/BrianHome/ " Then under aditional information i get: "Client found response content type of " , but expected text/xml The request failed with an empty responce. ( system.web.services) Try setting your TargetServerURL to: https://SERVERNAME/ReportServer and your TargetReportFolder to: /MainFolder/SubFolder This works for me. That works !!!! I can not thank you enough!!!! ...Show All

• Arun C Acquiring Connection manager Programmatically in SSIS

  hi all, I m new to this forum and hope i ll get warm welcome from all of you.... thank you I m Praveen kumar Dayanithi... a master student doin my assistantship in a Company. Kindly help me with this... Here is my issue.... i would like to know how can i pass arguments to connection manager programmatically. In other words how can i acquire connection manger through SCRIPT task(Vb script) . I know it is very easy to manually select n specify database name, table name by right clicking in dataflow task but in my company if i do that it will be very cumbersome for production people to change all the database and table names manually when the project is moved to production. Rather if i programmatically acquire connection manage ...Show All

• thatonedude Transaction Log and File Size

  Hi, Database transaction log file has reached to 1 GB and (99% of this space is free). When try to reclaim the unused space, I have no luck. Initial size of the transaction log has now reaches 1GB. When trying to change the initial size to 5 MB, it does not work. I have backup the transaction log with Truncate the transaction log but system is no releasing the space. Please Guide. Thanks Shafiq The easiest way to reclaim the space is to change a database option (change from full recovery to simple, or whatever you want to change) and then change it right back to what it was before. You will then be able to shrink the log file the first time you try it to reclaim the space. The ...Show All

• bsun Has "Select All" option been checked for Multi-Valued Parameter?

  Greetings. I have downloaded the patch to SP1 that restores the Select All choice for MVP. I am now wondering if there is a clean way (property ) to know if the Select All box is checked. My reason for needing this is that I want to selectively print a block near the top of the report that shows all of the parameters used to create the report. There are many blocks of parameters and each can have 5-10 possible choices. It would be much cleaner if I could print "all" rather than list all of the possible values, if in fact that category was not really used to filter the rows. Perhaps I need to build a dynamic where clause but I would rather not go to that trouble if I can use a built in feature or property. Thanks in ...Show All

• Jhedron Where are my "cube templates"?

  Newbie here: I'm using the SSAS 2005 "Cube Wizard". On the "Select Build Method" dialog I can select "Build the Cube without using a data source" but the option "Use a cube template" is not selectable. I did a custom install of sql 2005 and installed all sample databases, etc. but did I forget to install these templates TIA, barkingdog I The search on the forum will reveal similar problem reported :) http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=343836&SiteID=1 Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All

• Farhan H Soomro Distribution Calculation

  Hi Can someone please tell me how I can take a set of sales orders and generate a table or set of data that show the percentage of sales per product which are in different sales ranges eg Socks - Beige 50% Orders are above $100 20% Orders are above $90 and less than 100 30% Orders are above $60 and less than 90 Many thanks for your time TV Thankyou very much Louis If I want this distribution per store do i just add the following to it select StoreID, count(*), sum(case when value >= 100 then 1.0 else 0 end) / count(*) * 100 as [100Up], sum(case when value < 100 and value >= 90 then 1.0 else 0 end) / count(*) * 10 ...Show All

• robinjam sp_changemergesubscription

  hi guys, anybody have try use sp_changemergesubscription. I wanto change my subscription in SQL 2005 so it can use SQL 2000 publisher I have look to msdn http://msdn2.microsoft.com/en-us/library/ms143241.aspx but still can't figure it out. please advice A SQL 2005 subscriber cannot subscriber to a SQL 2000 publisher, this is not supported as pointed out in the link. Is this what you were asking ...Show All

• dreamer60 SQL Server 2005 - Service Account

  hi, By default SQL Server 2005 runs on "Local System" account. Is there a way to change it to "Network Service" account programmatically. Thanks, Loonysan Hi Paul, Thanks for the link. In the examples there - ServiceAccount class is only used with ServiceProcessInstaller to specify the context of the service. Is there a way to change the ServiceAccount of an already existing service. Thanks, Sankaranarayanan MG You should be able to programmatically manage any service with .NET. There is some sample code on MSDN that shows how to use ServiceAccount Enumeration. http://msdn2.microsoft.com/en-us/library/system.serviceprocess.serviceacco ...Show All

• r.matteja Which method to use for synchronization?

  I have three options in my mind to synchronize my data of sql server compact edition with sql server 2000/sql server 2005. 1)Merge Replication 2)Remote Data Access 3)Web Service All the data would be residing on Sql server 2000/2005 and user will get their data after being authenticated and will change the data and add new data and then again will synchronize with server with new changes. Please suggest me solution, my opinion is going towards Web service. Thanks Although this is definitely an option, you do need to consider where you want to invest your development time. If you want a synchronisation platform where you simply define the tables that you want to sync (rather than having ...Show All

• Aoeuid How to Access cube from ASP.NET

  Hi, I have developed a small code to access a cube, below : 1. Dim cnOLAP As New AdomdConnection( "Data Source=localhost;Catalog=[Analysis Services Tutorial]" ) 2. Dim MyCube As CubeDef 3. cnOLAP.Open() 4. MyCube = cnOLAP.Cubes(0) 5. Dim MyDim As Dimension 6. MyDim = MyCube.Dimensions( "Product" ) 7. Dim MyH As Hierarchy = MyDim.Hierarchies( "Product Model Lines" ) 8. Dim i As Integer = MyH.Levels.Count 9. TextBox1.Text = i.ToString When i run the code using internal web browser, I got this error : Either the user, MyDomain\user1, does not have access to the [Analysis Services Tutorial] database, or the database does not exist I noticed through deb ...Show All

• CruzPedro Can’t understand the Query execution interval, for every one criteria it takes extra 60 seconds. Help please?,

  Can’t understand the Query execution interval, for every one criteria it takes extra 60 seconds. Help please ,    Query A SELECT TOP 15 * FROM CMD4 AS T1 WHERE T1 . ST IN ( SELECT max ( T2 . ST ) FROM CMD4 AS T2 WHERE T1 . SERIAL = T2 . SERIAL AND T2 . sd = '20060817' ) AND sd = '20060817' --AND STOCKNAME like 'A%' ORDER BY D_CUM desc; The above query take 2 seconds to return result Query B SELECT TOP 15 * FROM CMD4 AS T1 WHERE T1 . ST IN ( SELECT max ( T2 . ST ) FROM CMD4 AS T2 WHERE T1 . SERIAL = T2 . SERIAL AND T2 . sd = '20060817' ) AND sd = '20060817' AND STOCKNAME like 'A%' ORDER ...Show All

• dilit Verifying MergeSynchronizationAgent no longer requires STA threading model

  I've seen a few posts in the MSDN documentation (see links below) stating that the MergeSynchronizationAgent no longer requires the STA threading model in SQL Server 2005 SP1. However, I'm still receiving the following exception message in my synchronization code (where it attempts to access the SynchronizationAgent property): The MergeSynchronizationAgent class must be instantiated on a Single-Threaded Apartment (STA) thread. I have Service Pack 1 for SQL Server 2005 installed on both my server as well as my local client (the client is running SQL Server 2005 Express). How can I verify the correct files are there (e.g. are the some specific date/time values for the RMO/COM objects Here's the list of MSDN links mentioned above ...Show All

• bkohler report colours

  Hi I have a report with 2 charts on it (a pie chart and a graph). The series are set out as : pie chart series 1 -total 1 - red series 2 - total 2 - blue series 3 - total 3 - yellow series 4 - total 4 - green graph (stacked) series 1 -total 1 - green series 2 - total 2 - red series 3 - total 3 - blue series 4 - total 4 - yellow as the 2 charts refer to the same info, i would like the colours of both sets of series to be identical - how can i do this thanks for the reply Ian. I got around the problem in the end by adding an additional column to the database which contains the colour references. I then use this column in the chart properties appearance. Not the be ...Show All

• DanglingChap Manipulating dates in SQL

  I need to generate a date range, based on the current date (or an input date). I can get the correct dates using VB, but I haven't worked out the TSQL Syntax for them yet. Can anyone tell me the TSQL syntax for manipulating dates in the following way... Start Date... This is the first day of the month, one year ago... in VB I worked it out as... dateadd( "yyyy" ,-1,(cdate(cstr(Year(now))+ "-" +cstr(Month(now))+ "-01" ))) End Date... This is the last day of the previous month... in VB I worked this one out as... dateadd( "d" ,-1,(cdate(cstr(Year(now))+ "-" +cstr(Month(now))+ "-01" ))) eg. for today 18/01/2007 I would get a Start date of 01/01/2006 and an End date of 31/ ...Show All