Answer Questions

• Aleniko29139 Time Dimension Browsing Very Slow - ProClarity

  Hello, I have a problem when browsing the time dimension (when cube cells have values) I have a standard time dimension with the following levels Year-Quarter-Month-Day. My cube has values for the years 2003 .... until 2006. 2002 Does not have values. When I browse the time dimension for 2002 (the year where cube has no values), I have no problem..but when I browse the dimension for values in the other years.... I wait until 1 minut to make a drill down in the dimension Pane (whitout executing the query). PS: I notice in SQL Server Profiler, that each time I browse the dimension in ProClarity, all my 80 partitions are read in the OLAP Server....without executing the query. Thanks in Advance Joao Campanico ...Show All

• redshock Error downloading trial version !!!

  Hi, I am not able to download the trial edition of sql server 2005. http://www.microsoft.com/downloads/details.aspx FamilyId=6931FA7F-C094-49A2-A050-2D07993566EC&displaylang=en From this page when I click continue to do the registration, it displays a page not found error !! Can you plz fix the link thanks atforum wrote: Hi, I am not able to download the trial edition of sql server 2005. http://www.microsoft.com/downloads/details.aspx FamilyId=6931FA7F-C094-49A2-A050-2D07993566EC&displaylang=en From this page when I click continue to do the registration, it displays a page not found error !! Can you plz fix the link thanks There seems to be some issues. ...Show All

• Jonathan Abbott Newbie looking for direction

  Happy Friday afternoon, all, My task is seemingly simple. I have data on the server in MS Excel Files. I need to get the data into multiple tables in a SQL Server db on the same server. I have been only working with SSIS for a bit, so please bear with me. I can load the data directly from the Excel worksheet to one table, but I need to run an already defined stored procedure on the data from Excel before putting it into tables. I need to loop over all the rows and run the data from each row through the stored procedure. So, I think I need an Execute SQL Task withing a For Each Loop, but neither is available on the Data Flow page, and I don't see how to use them in the control flow page. I don't see that any of the Data Flow tr ...Show All

• Baok subreport containing a report from another folder

  hi all, can a subreport point to a report from another folder in the same SSRS server. In msdn it's given that they are usually in the same folder as the parent report. In the xml schema of RDL, there is no Path tag for subreport, only name property is there. If we set the name property to a report from another folder, it gives error while displaying the report. can anyone suggest if it is possible or not, if possible then how to achieve this thank you, Srinivas You can define the subreport from the root of the report server directory. /Folder name/Folder name/subreport name ...Show All

• Thomas S. Andersen Derived Column / Change date format

  Hi, Is there a way using a derived column transformation to change the format of the date eg: The input flat file's date is in yyyy/mm/dd and i need to convert / change this to yyyy/dd/mm Is this possible Thanks in advance, Slash. Substring and concatenation, perhaps The weird thing is that the original flat file date is all yyyy/mm/dd but when it comes to import into the database as datetime. It inconsistently changes the format of the date some dates appear correct and some appear as yyyy/dd/mm. Is there anyway to over come this / have you heard of anything like this before Thanks for the replies, Slash. .. would work because it ...Show All

• Manivannan.D.Sekaran sql server remote connections fail

  i installed sql server express, but i did not select to use mixed mode (the reason being for this that every time i did i got a install coruption error) i want to be able to connect the database remotly using the sqlservers jdbc driver. however i need a user name and password. therefore to do this i believe i need to be able to acess the database remotly. ive tried everthing: 1. changing the surface area remote conenctions to allow remote connections using tcp and ip only 2. restarted the database 3. restarted the server 4. restarted the browser 5. checked the tcp/ip settings are enabled. but when i do the follwing in command line i get this: C:\>osql -E [SQL Native Client]VIA Provider: The specified module could not be found. [SQL Na ...Show All

• 3Nu Concatenate strings after assigning text in place of bit strings

  I have a whole bunch of bit fields in an SQL data base, which makes it a little messy to report on. I thought a nice idea would be to assigne a text string/null value to each bit field and concatenate all of them into a result. This is the basic logic goes soemthing like this: select case new_accountant = 1 then 'acct/' end + case new_advisor = 1 then 'adv/' end + case new_attorney = 1 then 'atty/' end as String from new_database The output would be Null, acct/, adv/, atty, acct/adv/, acct/atty/... acct/adv/atty/ So far, nothing I have tried has worked. Any ideas I solved my own problem: I needed to include an else statement select fullname, cas ...Show All

• Mark Dahl Error installing SQL Server 2000 Developer Edition

  Hello, I hope someone knows the answer to this issue. I am trying to install SQL Server 2000 Developer Edition and once I get to the screen that is asking for the SQL Server instance and Login Information I receive the following error when trying to proceed. (Report Server database is a different version and cannot be used for this installation) I have installed reporting services 2000 developer edition many times and I have never seen this error. I ran into the same problem installing Reporting Services on a new web server and I deleted the Report and ReportTemp databases form the server and then the install went fine. Are you adding a new Report Server to a ...Show All

• milehighmounty SQL 2K move to new domain

  I have SQL 2000 running on windows 2000 using NT4 authentication all my users authenticate to the NT4 including their access to SQL 2000, we are moving to a new domain using windows 2003 server and Active Direcory. We will be a an OU in a much larger domain (about 30K users) since we need to be able to be up and running with ability to authenticate and run all our apps including SQL server authentication in the event we loose our connectivity to the rest of the world should a natural disaster hit us. Here is my dilema, when I see my users in SQL security they all have domain\userdID where the domain is my old domain. How do I move all my SQL users with their rights to the new Windows2K3 SQL server that will authenticate to a Windo ...Show All

• Leon Tayson DBCC CHECKIDENT (jobs, RESEED, 30) does not work

  Hi, I'm trying to set up merge replication and when I try to synchrinize with the subscriber I get the error "invalid column name ROWGUIDCOL". Following an article it recomended to reseed the identity columns on the subscriber so that there is no conflict. Now the tables with the identity column have the "Not for replication "option on. Using DBCC CHECKIDENT (table_name, RESEED, some_value) does not change the SEED when I check. SQL server help file remarks on DBCC CHECKIDENT say that if the column was created with the "Not for replication " option on it cannot change the value. From sql server help file: Remarks If necessary, DBCC CHECKIDENT corrects the current identity value for a column. The cu ...Show All

• lucerias Alternative for Cursor use

  I am having a table that has a column called sequence which stores the sequence of Chapter and can be changed by user.Sequenece can vary from 1 to n. Structure of table is Id int CourseId int Chapter varchar Sequence int and sample data is Id CourseId Name Sequence 1 92 Chap1 1 2 92 Chap2 2 3 92 chap3 3 Now, when i delete second record i.e. Id=2, I want that sequence of Id=3 should become 2. For this I am using cursor. CREATE TRIGGER [Et_TriggerReOrder] ON [dbo].[ET_CourseChapter] FOR DELETE AS BEGIN DECLARE @id as integer DECLARE @Sequence as int DECLARE @Count as int DECLARE REorder_cursor CURSOR FOR SELECT [id], [Sequence] FROM ET_CourseChapter WHERE courseid = (select courseid from deleted) order by [Sequence] OPEN REorder_cursor FET ...Show All

• ShayEr remote webwork place

  We have a SBS2003 server. And configured remote workplace to allow remote users access to their workstion. On the windows XP Pro sp2 station I have added the user to the "Remote desktop" list ( control panel-system-remote-allow users to remotely connect this computer - Add .) Nomal users can pass router and select wanted station then get logon screen. But this error message is showed up: "The local policy of this system does not permit you to logon interractively." The administrator can logon to any station remotely. Do I have to give additional permission to normal user Thank you for any help or clue. Peter Hemantgiri, Thank you very much. It solved my pr ...Show All

• AlexBB reporting services connection error

  I think i've tried everything. I have sql server installed on my machine and vs.net as well. I have the report server on another machine. I've made reports in vs.net and deployed them and they show up in the report manager but when i go to view i get the error: An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'SANDO'. (rsErrorOpeningConnection) SQL Server does not exist or access denied. what sort of connection type should i use and can someone tel lme the steps to get this to work right any help would be appreciated thanks so much Delete the datasource and all the rdl files from the reportserver and redeploy them again. ...Show All

• csalsa like keyword que

  I have a table say tbl1 id col1 col2 1 hello hi 2 aaa bbb 3 kkk lll I want to write a proc which has a parameter @val and I want to select records from tbl1 based on either col1 or col2 like @val the query describes better than my writing select * from tbl1 where col1 like %@val% or col2 like %@val% but this is killing the performance of the procedure, can I write it in different way How can I improve it Thanks Another alternative is full-text search. Another expensive alternative I've used a couple of times is to create a scheme of indexes to support middle search. It can work either as an indexed view or an auxillary table for storing the " ...Show All

• Pockey Aggregete() function doesn't work for SQL query results! - Part 2

  I am writing my own MDX query inside Reporting Services, bypassing the graphic MDX generator. Both MDX query and SQL query return identical results and both have detail level values and high level values. During the flattenning process, null value from MDX is still null, but null value from SQL is translated into blank. Thus only the MDX result works for Aggregate() function, not the SQL result. Because Aggregate() function is triggered by null value, not blank. Someone suggested to use MDX stored procedure to do custom calculations. Thus my report is calling a MDX query, not a SQL query. I have tried this approach already, but MDX is not as flexible as SQL. For example, in SQL, I can easily join, pivot, order by, group by, fil ...Show All