Answer Questions

• Peca55 Top 10 with ties

  I have the following tale that appears like this: IMAGE Its show the top 10 company, with the top 5 sub companies underneath in a table where I use the filter TOPN = 10 . My problem comes in when I have two company that exist in the top 10 with the same value, in this case $0.00 it shows more than 10. I understand that using the top = 10 in sql reporting services is suppose to function like this, but want to only show 10. My SP looks like this: SELECT SicDescription, ISNULL(Company, 'OTHER') AS Company, AccountMV, AccountFeely,sicid,relationshipid as 'rnumber' from snapsraw WHERE (Branchstate = @state) AND sicdescription is not null AND (monthend = @date) Any help would be greatly appreciated, I heard of some people saying use the ...Show All

• jwraith Sql server setup

  Hi gurus I am new to sql server and I am in the process to deploy one on my small enterprise, I would like to know if someone can help me, on how to setup the server to better take advantage of the HD,Raid,performance. I have a server with two procesors ,8 ram, total of 5 HD(3x15k and 2x10k) I would like to know what would be the best way to setup the raid and where to install all componets of sql server on this machine. Thanks a bunch guys Sorry you , no I am sorry for the battle, thanks again for battling with me here All my drives are the same size, they are all 146GB but two of them are 10k rpm and 4 of them are 15K rpm, so, do I still keep the same config as per your advice ...Show All

• GrandpaB detect licensing

  Wondering if I can use SMO/DMO to detect licensing for SLQ server. Either CAL or by processor SELECT SERVERPROPERTY('LicenseType') The result I get is DISABLED. SELECT SERVERPROPERTY('NumLicenses') seems kinda buggy TIA, Joe ...Show All

• rileyt Saving a report built in Report Builder

  I have built a report using Report Builder. When I try to save it I get and error, The name cannot contain any of the following characters: ; @&=+$,\*<>|", and cannot consist exclusively of dots or spaces. The name I am saving is cta. Any ideas I do not think so. Did you install anything special on the web server, like front page server extenstions or disable the firewall or open a port in the firewall. Did you just do a vanillla install of reporting services or did you add pieces on afterwards (don't know what these wou ld be) Hi GTO52, cta. Works fine for me. Is there some other character you are using ...Show All

• max-holz Very confusing error about timeout and estimated-cost of query

  Hi, I created a cube from one fact table named Revenue. It's total records was about 16.8 million, consists of 12 partitions, distributed quite even (so about 1.4 million records per partition). The partition was based on month. Each partition is mapped to different file-group. The data file for each file-group was 340-360 MB (350 MB in average). The total size is about 4.2 GB. The cube involved 5 dimensional-tables. One of dimensional tables was time-dimension table. 3 out of 5 was for hierarchical region tables. The last one of dimensional tables was product- dimension table. Each of these dimensional tables are very small, less than 1 MB. The cube contains very few columns. It contains 6 columns from 3 (dimensional) region tables, 3 col ...Show All

• Shaantu drill-through feature in a pie chart

  Hello, Assume I have a pie chart report named as Report 1 . This report breaks down a completion state column in the X table . Here is my question; I want to create another pie chart report names as Report 2 , which breaks down the message column in the X table on the basis of a given completion state . In other words, Report 2 should be on the basis of a given completion state, via drill-through from Report 1 . Thus, when I click the different slices of the pie chart of Report 1, I should get a separate pie chart report (i.e. Report 2), which breaks down the message column on the basis of a given completion state Please let me know if you have any idea Sincerely, --Amde Now it is workin ...Show All

• Greg Van Mullem Get number of business days between dates

  Hi. Is there a way to get the number of business days or hours between two dates Also, is there a way to have it ignore weekends and U.S. holidays Thank you. i am using this script to get amount of business days Code Snippet set datefirst 1 declare @sdate datetime declare @edate datetime select @sdate = '20070516' --for example, start date May, 16th select @edate='20070531' --end date May, 31st select datediff(day, @sdate, @edate)+1-( select (case datepart(dw, @sdate) when 7 then (datepart(ww, @edate)-datepart(ww, @sdate))*2-1 else (datepart(ww, @edate)-datepart(ww, @sdate))*2 end)+ (case datepart(dw, @edate) when 6 then 1 when 7 then 2 else 0 end) ) ...Show All

• Rohit Tela Cannot run the script of SQL Server 2005 t0 SQL Server 2000

  Hi all, i have a database in SQL Server Express Edition. i generate the database script from the database>All Tasks>Generate script Option. That script is not running in SQL Server 2000. I set the property of the database to compitible with SQL Server 2000 and i also set the property when generating script for 2000 version. still i get the same error. Am i missing something. Please tell me how to do this Even with compatability level set down, you can't expect a script to be compatible if you used any SQL Server 2005-specific features.  You're going to have to do a find/replace and fix it up to get it working.  What errors are you getting   Remember: ...Show All

• jpcesar Lots of data/Performance Question

  Which is better for performance, 1 large table, or a collection of smaller tables, all identical to each other, except by name Ok, let's say I have a users table (id, firstname, lastname, etc...) and a single master "downloads" table, containing a record for every download recorded on a website. In the master downloads table, you would have the following: DownloadID (Primary Key) UserID (Foreign Key to UsersTable) FileDownloaded (name of the file) DownloadDateTime (date/time of the download) I could alternately set up a new table for each user, named something like "Downloads_<UserID>". The structure would be: DownloadID (Primary Key) FileDownloaded (name of the file) DownloadDateTime (date/time of the downl ...Show All

• OniShiro Issues with 1.1 framework calling SQL 2005 CLR sprocs?

  Are there any issues calling SQL 2005 CLR bases stored procedures and functions from a web application which uses the dotnet 1.1 framework I assume not, but would like advice from those who've been there... Thanks, Marie Hi, no there are nor problems. Even calling SP from other program with the MDAC stack does not bring any problems. You will not be able to use certain features as they are only supportedby the ADO.NET 2.0 framework (like query notification) but there any no problems with the "old" functionality. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Thanks Jens! ...Show All

• p.hansen SQLConnection fails from Windows Service

  Hi, I'm currently writing a windows service which will generate XML documents for FTP upload. When running the service the goal is to get records from a stored procedure, then generate the XML documents. When running the service (lokal service account) the connection fails; instead of using the supplied connection string, it defaults to the LocalService account. How can this be solved Thanks in advance In this case, you just need add account "<domainname>\<computername>$" to your SQL Server. Thanks! Ming. Thanks... but the SQL server authentication is running in mixed mode. So that isnt the problem. For some reason the service l ...Show All

• MisterMoon How to Deploy Report on Remote Server..

  Hi, I m getting following error while deploying report on remote server... Error 3 The permissions granted to user 'ZENITH\BalwantPatel' are insufficient for performing this operation. 0 0 The following setting i have on my remote server. Configure Report Server: Report Server Virtual Directory: Default Report Manager Virtual Directory: Default Windows Service Identity: Service Name: Report Server Service Account: Domain\Administrator Windows Account: Domain\Administrator. Web Service Identity : ASP.NET Service Account: ServerName\ASPNET I m creating Report on my local machine as Domain\Balwant Patel. and Trying to deploy on other server ...Show All

• Grae Foster simple text processing e.g. regex search and replace

  I've got an nvarchar(max) column that I need to transform with some simple text processing: insert some markup at the very beginning, and insert some markup just before a particular regular expression is matched (or at the end, if no match is found). Since the SSIS expression language doesn't support anything like this, is a Script Component the only way to go Does Visual Basic .NET provide regular expression matching Thanks! Duane Douglas wrote: Kevin Rodgers wrote: Duane Douglas wrote: there is no need to use a script component or create a custom component because microsoft already provides a regex component for ssis: http://www.microsoft ...Show All

• JBClifton Any permittedHost email security change lately?

  UPDATE. I am now checking with our IT if the SMTP corporate server has the correct relay authorisation for the new server. I may have overlooked this issue. Hello, Om my previous report server, I had not set amy DefaulthostName nor PermittedHost. This allowed us to create subscriptions that get sent to our business partners with a long ever changing lists of email addresses and domains. All server are build 2175, they ahve the same rsreportserver.config setting for the email portion. Problem is that on 2 of the servers, the email with a domain other than our internal domain do not get sent with error "The email address of one or more recipients is not valid". It works on the third server. I tested ...Show All

• BitShift SQL Server Agent Properties - History

  When you select 'Automatically remove agent history' with the parameters 2 months, it actually removed all but 2 DAYS ! This ruined 3 of my production server job histories. It also does not retain the parameter settings on this History page, not that i want to use this screen anymore until this parameter item is fixed. My expectation is that the GUI screen option work correctly. I do not find exporting history to be an acceptable option, besides i have already lost my history. Which version of SQL Server being used here We never had such problem on our settings. In this case you can export the job history to a flat file and keep it archived for history ...Show All