Answer Questions

• programmer01 Concatenate Rows into Columns

  I have a table 2 columns (Object and Weight) with data like below: Object Weight(lb) table 5 Chair 6 Computer 3 Computer 5 TV 20 TV 15 Radio 10 Computer 10 Question: I would like to create a new table with one column that would join the above two columns like below Object table 5 Chair 6 Computer 3, 5, 10 TV 20, 15 Radio 10 Thanks for your help in advance. Yet another way to do it, using data from one of the other posts, and the 2005 techniques from: http://databases.aspfaq.com/general/how-do-i-concatenate-strings-from-a-column-into-a-single-row.html Create table tbl(Object varchar(100), Weight int) insert tbl Select 'table', 5 union all Select 'Chair', 6 union all Select 'Computer', 3 union all ...Show All

• Jocker23 Rowversion as a history mechanism

  Hello, I have a requirement to maintain a 'history' table beside a products table. Any time a row is changed (added/removed/updated) in product table I need to add a new record to the history table. I would be using a rowversion column in the products table. And would want that rowversion to be preserved in the data on the history table ... So I'm thinking I'd use a trigger etc..thats no a problem, I can manage that... What I'm wondering about is what datatype the column to hold the rowversion in the history table should be I'm thinkin that it shouldn't be a rowversion because I don't want it to change value in any automatic way... or even get mod'ed by the action of actually inserting the record into the history table.... So, may ...Show All

• Lok_Tan All that extra whitespace that displays in HTML

  So I have a footer row in a table that is set to 0 height. Actually it is set to 0.03125in because SSRS doesn't allow a 0 height, but whatever. When I view this in the designer preview, life is good. The amount of whitespace on each footer is minimal and a minor nuisance. But after deploying to the server and viewing in the web browser, the whitespace is much more pronounced. Any special reason why these display differently, and any way to shrink down that HUGE row whitespace Can't you just select the whole footer row and delete it if you are not using it for anything That would eliminate the space on the report. Please give me a little credit. I know how to delete a row. No that won't work. This is a sweet little workar ...Show All

• LazyGenius temporary table not dropped after user disconnected (SQL2005)

  Hello all, We are developing some stored procedures on the SQL2005 server. All of them use local temporary tables to store temp data. Due to some errors in the procedures, run-time errors are produced and the procedure stopped. But after user disconnected, these temp tables are still exist in the tempdb and cannot be deleted. We can only view these objects using SA account in tempdb.sys.objects view. I would like to ask if there is any method we can delete those unused objects Thanks a lot! Bryan I do not think you can manupulate this objects(e.g. drop them). But, who knows...:) Just found some article about tempdb in sql 2005: http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtemp ...Show All

• Jassim Rahma Upgrade issues

  I have a database in SQL2000. What are the issue that may arise if I migrate database to SQL2005. I m lookin' for feature which are not supported in sql 2005 which may cause my stored proc's not run- forexample Empty SET clause is not allowed in SQL2005 Hi Samuel Thanx it was a great help. I have also found out some changes here: http://msdn2.microsoft.com/en-us/library/ms178653.aspx The best way to prepare for an upgrade is to run SQL Server 2005 Upgrade Advisor.  This will give you a nice report of which features are no longer supported from SQL 2000 as well as features that may be deprecated in the future. Here's the link: http://ww ...Show All

• Hoopla Localization of Report Manager to Portuguese

  Hello to all! I want to translate de interface of the Report Manager to Portuguese. I'm develop a class that implements Microsoft.Reporting.WebForms. IReportViewerMessages The class is in a file called "ReportViewerMessages.cs". The structure is like this, the project is called "PortugueseReportManager", there is a namespace named "PortugueseReportManager" and the name of the class is "ReportViewerMessages". So far so good, but when I change de web.config file in the report manager folder I'm getting over and over this error message when I try to see a report: The type PortugueseReportManager.ReportViewerMessages, PortugueseReportManager, Version=1.612.19.1, Culture=neutral, PublicKeyToken= ...Show All

• Microsoft_hates_me SQL & Passwords

  If it's possible, I'd like to embedd a password in an app that connects to a supporting SQL database. The idea is... the user doesn't use the password... only the app when interfacing with the dB to prevent others from taking the dB for something else. Anyone has a guide The dB is already fully operational. I was thinking about encryption, but I don't want to slow down the dB. I would need to know how to add Password to dB and how to send password from the program. Thanks. It uses Windows...[Database properties: Modify Connections]. I tried SQL Authentication by adding a user and password in the boxes, hoping that the dialog would add it to the dB - but no luck. ...Show All

• xzhang9 $25,000 per processor for this?

  What is wrong with Microsoft How could you honestly release this product I agree with everyone else - the new features in SQL Server 2005 are not worth losing the features in 2000! I'm telling my clients to not upgrade. You guys had better release a new version or upgrade fast. mySql is starting to be a real competitor. I can no longer justify your cost. I happen to agree with you about how you describe your disatifaction. Most likely MySQL is your best choice. However, all of my clients have most definitely found that upgrading to SQL 2005 to be well worth the time and expense. I wouldn't consider using MySQL at all since SQL 2005 provides so much functionality that the time and effort to p ...Show All

• Rob Harris full outer join

  Hi, i want to replace a full outer join statement . how do i i am more in control with '=' thanks/ Hrubesh: If what you are asking for is syntax similar to the old *= and =* for left and right outer joins I think that there was never a Transact SQL equivalent for the FULL OUTER JOIN operator; moreover, the *= and =* syntax are no longer available in SQL Server 2005. Is this what you are looking for Dave Can you expand on your question I'm not sure I understand. What is the SQL that you are trying to convert and what do you want it to do Okay i had a look on outer, inner joins. Till now the worst sql i had to do were enough to do with strait forwd = , usi ...Show All

• Ola Hallengren Full-Text Search Error - Server: Msg 7635 The Microsoft Search service cannot be administered under the present user account.

  Hello and thank you for your assistance.  I have two instances of SQL Server 2000 Enterprise Edition (SP4) database running on Windows 2000 Enterprise server.  The default instance is dev and a named instance for QA.  Full-text search is enabled for dev and is functioning properly. @@Version: Microsoft SQL Server  2000 - 8.00.2040 (Intel X86)   May 13 2005 18:33:17   Copyright (c) 1988-2003 Microsoft Corporation  Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4) I am trying to enable full text search in the QA instance with this command: "sp_fulltext_database 'enable' ", but I am receiving the error "Server: Msg 7635 The Microsoft Search servi ...Show All

• brettlee01 Undo Changes in Table Help!!

  I accidentally executed this query Update Table Set Field = 1 Where Date < dt I need to undo this, is there i way to do so Havent touch sqlserver since the execution of that query. Hi Giber, If you are using 2005, you may be able to restore the pages that were affected, however the easiest solution may be to restore the database backup to either another server, or same server but under a different database name. You would then be able to revert to the unchanged/correct table be referring to the restored db backup. Have a look at http://msdn2.microsoft.com/en-gb/library/ms191253.aspx for an overview of backup options etc. Cheers, Rob The server makes a backup daily of the whol ...Show All

• Xefan more help on partition

  i created a wrong left-ranged partiton function named wrongpf wrongpf is being used by partition scheme ps1 to partition tablex to 24 partitions. to rectify the error I create a new partition named rightpf testing the data using $partition function shows that the set of data that will be switched in to tableX are aligned to partiton function rightpf. partiton scheme ps1 can be used by either rightpf or wrongpf question: 1. what are the steps to partiton the table using partitonfunction rightpf 2. is it possible to alter partitonfunction wrongpf to a right-ranged partiton without the need of creating or using rightpf 3. can the table be altered (alter table) to used the primary filegroup and be swicth to use a ...Show All

• Maestro IIF question regarding grouping

  In my report, I have a formula to calculate an average: =sum(Fields!GPF.Value)/countdistinct(Fields!Unit.Value)/7 This is grouped by the field Region. On the summary line below, the same formula is used, but with no grouping - it's for the entire company. What I'd like to do is change color of the text in the detail line to red if it is above the average in the summary line. I know how to do this with the IIF statement. What I'm not sure is what to do with the comparing, since the same formula is used in both places. I can't very well say: IIF(sum(Fields!GPF.Value)/countdistinct(Fields!Unit.Value)/7 > sum(Fields!GPF.Value)/countdistinct(Fields!Unit.Value)/7, "Red", "Black") Any suggestions to a ...Show All

• Whoisit SQL server 2005 express and MS Project 2003 server

  Does anyone know how to install MS Project 2003 along with SQL Express 2005. Glenn, I'm reading the docs w/ Proj Srv 2003 and it says it needs SQL server 2000 and the website says just SQL server. Am I to assume that I can use a newer version off that Thanks Try this link: http://blogs.lv0.net/mpatest/archive/2005/11/18/182.aspx Talks about steps you need to take to install Project Server 2003 with SQL Server 2005. And yes, if you want to be able to run the Portfolio Analyzer you will need to install SQL Server 2005 Enterprise Edition with Analysis Services. - Larkin Looking at the Req ( http://www.microsoft.com/office/project/prodinfo/server ...Show All

• Sebastiang Problem with connecting to SSAS and also deploying projects to SSAS

  Hi, although I read thru several threads I still did not really find a solution for my problem. I have installed a SQL server on a server, including all components (SP1 is already installed) but I cannot connect to SSAS nor can I deploy a solution with BIDS. I receive the error message Error 1 The project could not be deployed to the 'server\instancename' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. As far as I understood other threads it ...Show All