Answer Questions

• deadlock07 Subtotals broken in Report Builder?

  Sub-totals are not working as I would like/expect in an end-user tool when dealing with data from a relational schema with cascading 1-Many relationships.  Instead of performing aggregation at the level of the source table, it is blindly performing aggregation on the result set, causing incorrect results. An simplified hypothetical example will make this clear. Imagine the following relationships: Table "Patients"  related 1-many on p ...Show All

• Ryan Hanisco XSD: Reading string in ROOT of XML

  Hi all, I am making a import from XML to SQL. I have chosen to do this via a XSD file, but I have a problem with the ROOT file of the XML XML: <Dogs bulkmode="0" xmlns=" http://scheme01.isp.com ">   <UnderDogs>     ...   </UnderDogs> </Dogs> XSD: <xsd:element name="Dogs bulkmode="0" xmlns=" http://scheme01.isp.com "" sql:is-constant="1"> Unfortunately this does not work. If I (for testing) ...Show All

• ItsJustJake how to use CASE or IF in SSIS

  All, what's data flow task works with CASE to IF CASE WHEN . ACTION = 'TER' THEN COL 1 ELSE COL 1 end Thanks The Derived Column transformation allows you to do this. This is the operator that you're interested in: http://msdn2.microsoft.com/en-us/library/ms141680.aspx -Jamie ...Show All

• meedietoo set up problems by sql express edition 2005

  TITEL: Microsoft SQL Server 2005 Setup Problem ------------------------------ SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof. By compiling with mofcomp sqlmgmproviderxpsp2up.mof : can't find class , instance of property CIMTYPE. Who can help me Henk ...Show All

• George Ionita Sample Data for mining

  hi, i am bit new in the field of data warehousing and data mining but catching up fast. I am in the last year of BS(Computer Science) and intend to do a project on a Business Intelligence but i was wondering can i get a sample dummy data for my work is that any way possible Try here http://kdd.ics.uci.edu/ Also try the movies data set at www.sqlserverdatamining.com ...Show All

• Alexander Klizhentas Deploying reports on 2000 Reporting Serve

  We have RS 2000 runing. Can we create reports in RS 2000 using Visual Studio 2005 No, the editor in VS 2005 uses the new RDL schema. VS 2003 and 2005 should run side by side. ...Show All

• jockofett Conditionally dropping a table

  To All How do I check to see if a table exists before I drop it. Thanks David Davis Tyler Free Thanks works like a charm David Davis if exists (select * from dbo.sysobjects where id = object_id(N'[MyTable]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [MyTable] GO The easiest way to check this in SQL Server 2005 is to use OBJ ...Show All

• markchimes2 Fixed width output problem

  I'm sending the results of an SSIS data flow to an fixed-width flat file output, but instead of getting separate rows of data, like so: row1data... row2data... row3data... etc... I get: row1data...row2data...row3data...etc... Is there some setting I'm missing in either the flat file output or the file connection to turn this on The fixed width format does not include the row delimiters. You can ...Show All

• K&amp;#58;&amp;#58;ot&amp;#63;&amp;#63;&amp;#63;ter Sql Enterprise Manager Customization

  Using SQL SERVER 2000 - Enterprise Manager Can add-ins be made against the Enterprise Manager snap-in I wanted a way to filter tables so only those matching specific text are seen. Ide also like to do more, so the ability to create an add-in would be ideal. Thanks E ...Show All

• Igor I.I. KPI value expressions

  I'm trying to understand what forms the value expression of a KPI can take. All the sample I've seen so far have been very simple, like a simple measure expression, e.g. [Measures].[Internet Sales Amount] I've also had success specifying a simple tuple, e.g. ([Measures].[Internet Sales Amount], [Product].[Product Model Lines].[Model Name].&[Bike Wash]) But what if I want something more a little more sophisticated For example, what if I want ...Show All

• Paul.Brown installing SQL

  I am trying to install SQL enterprise 2005 edition on an XP machine. Is it true that this will not work The config. manager appears but nothing else. If so, will the express version work Thanks in advance. Robert Why do you say that it hasn't installed SQL What's missing http://msdn2.microsoft.com/ms143506.aspx I have now installed the express edition instead (a ...Show All

• Alex Ellis installation bug found SQL Server 2005

  Hi! I had the earlier builds and this did not happen but: just downloaded SQL Server 2005 (RTM) from msdn When selecting to install integration services (amoungst other options), whilst installating it gives me an error saying I do not have admin privledges to install one of the .NET libraries/runtime files I cannot remember the file name at all im afraid. Error: 0x80131501 So I cancelled the install and just installed everything but the in ...Show All

• Lalaa Displaying a SQL Server Report 2005 in a PDA....

  Hello All, Good day! I have developed a report using SQL Server Reporting Services. I can view the report in a Browser, but when I try to view the Report in a Pocket PC 2003 Emulator, the report displays but without the data or the contents of the report.... I tried appending &rc:=HTML3.2 to the end as suggested by in one of the posts but no luck.... Any suggestion or directions will be higly appreciated.... Regards, Sri ...Show All

• RWendi Combining text data rows

  I am working with a database derived from text documents. One of the tables (TEXT001) contains the text of the documents with each paragraph of each document assigned to its own row with a paragraph number in a SectionNo column. I want the entire text of each document in a single row with its own unique number (so that I can do a full text search with SQL Server 2005 that will search and return the entire document as a result). How do I comb ...Show All

• Marisa Seal Security levels of CLR code when deployed to another server.

  Hi, My question kind of covers a couple of areas. I have written some SQL 05 CLR code that produces a single DLL file. I have specified that the code is 'Safe' e.g. it will not be carrying out any external assembly access or other file accesss. The code simply contains some stored procedures that will update/instert etc data from the database. The question is, how do I actually deploy the code to a a remote server Do i simply take t ...Show All