Answer Questions

• NateLucy Nested data region and data sets

  Hi, I just want to know if nested data region (e.g. matrix nested in a list) support different data sets. i.e. I have 2 data sets, dataSet1 and dataSet2 and want to display in a matrix (dataSet1) nested in a list (dataSet2), does it work Thanks.   Nested data regions do not support different data sets Note: you could join the two datasets in the query and then use this new dataset for both the list an ...Show All

• Huzefa Major SQL Server/SSIS 2005 Performance issue

  SQL Server 2005 is installed on a brand new 64-bit server (Windows 2003 x64 std. Edition, 2.4 Ghz AMD opteron- 2cpu, 8.8 Gb of RAM). There is barely few hundred rows of data scattered among few tables in one database. SQL server and SSIS performace grossly degrades overnight and in the morning everything is slow including the clicking of tool bar selection.It takes 3 seconds to execute a simple select statement against an empty table. It t ...Show All

• iNVERTED Thanks to replay,but my problem also unresolved

  How I can rectify divide by zero exception in stored procedure i know it, but actually I want that display 0 or my error message instead of server error message. Thanks for ur suggestion, but I already solved it by case method it goes too much bigger but it gives satisfied results well, ur answer giving very well theoritical concept, Thank u once again, Next I will send u another query, if i have OK - so your database de ...Show All

• Richard Tong Foreach Loop Enumerator Question

  Any help appreciated here... I'm inserting a CSV file into my SQL Server 2005 Sept CTP which has approx 1700 rows.  It contains Companies and Contacts which I split in a data flow and determine if with Fuzzy Lookups whether dupes exist and perform either insert or update (That works great).  Here is my issue: The database does not use Sequence for the Pkeys and to make matters worse they are prefixed with letters.  I have to gene ...Show All

• Nitwit SQL Server Authentication + SSL

  Hi! I noticed that with SSL authentication (On SQL Server 2005), the SSL handshake is kind of "truncated" : * Certificate is not sent from Server to client; (Which may be OK according to TLS) * The client does not send Client-Key-Exchange message (Which is not conforming to TLS) This is clearly evident from tcpdump output. However with Windows authentication, the client -server handshake is "compatible" with ...Show All

• BigFred Doing away with like '%%'

  Here's the setup @searchcondition varchar(50) --is a parameter passed into a stored procedure IF(@searchconditions is null) BEGIN SET @searchcondition = '%' END ELSE BEGIN SET @searchcondtion = '%' + @searchcondition + '%' END select * from sometable where somecolumn like @searchcondition Now the procedure is fine if the user passes a string, but if it's null, it seems really inefficient to search for '%'. ...Show All

• biju7630 Using expressions in other expressions in SSRS 2000

  All the other reporting tools i've used have the ability to give the result of an expression (formula or calculation) a name (or load it into a variable) and include it in another expression (formula or calculation). I can't find this functionality anywhere in SSRS 2000, does it exist Thanks. Hello Fang Wang, I read your article/code on custom aggregates at ( http://blogs.msdn.com/bwelcker/archive/200 ...Show All

• arianraj Problem with Union ALl

  I want to combine 4 columns and map those 4 to respective fileds in the target database.For this..when i used "Union All " its going for cross join and filling the columns with Null vlaues.. Like If each column has 5 rows ,iam getting (4* 5 =20) 20 rows Is there any solution to avoid for this and to get the 5 rows Thanks Kumar sorry small mistake . when using UnionAll getting output like this Like ...Show All

• jim_slc Changing Column size/type with Derived Column

  I have a number of date columns that are parsed as DT_WSTR (6) and I have written a Derived Column converting them into DT_DATE via this (found on the forums) type expression: (DT_DATE)(SUBSTRING(Date,6,2) + "-" + SUBSTRING(Date,8,2) + "-" + SUBSTRING(Date,1,5)) But I really want to replace the current column, not create a new one. If I use "replace" the data is forced to be a DT_WSTR (6), and I get a truncation error at run-time. Simeon ...Show All

• Claudio V. User-Defined Datatypes based on abstract classes

  I am trying to create a set of spatial datatypes for SQL Server 2005. Each datatype inherit from the abstract class "Geometry". ie.   public class Point : Geometry   public class Line : Geometry   public class Polygon : Geometry ...and several more. The reason for using the abstract class Geometry, is that they all share a common set of functions that return a Geometry object. For instance   Geometry Intersection(Geometry g1, ...Show All

• Mark Naughton Error in X-Path Query

    I am new to XML in SQL Server and X-Path Query Recently I have done the following virtual lab in techNet site SQL Server 2005 XML Capabilities The following query is worked fine in the lab SELECT TOP 10 Demographics . query ( 'declare default element namespace= "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey" /IndividualSurvey/YearlyIncome' ) FROM Sales . Individual But later ...Show All

• Jo Molnar - MSFT error: 40 with sql server 2000

  Hi I am getting this really annoying error that I cant resolve. I have created a website that accesses a SQL SERVER 2000 database and it works perfectly on my home machine. The error has occurred when I have transferred it to my hosts server. This is the error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default ...Show All

• Richdz Display Row Data As Cols

  I have data in rows that I need to aggregate and display in a columnar fashion and I haven't been able to figure out how to do it. A simplified version of the data as it is stored in the table: Station Month Day Reading 1 1 1 100 1 1 2 200 1 1 3 300 1 2 1 400 1 2 2 500 And I would like to create a query that returns: Station Mo ...Show All

• MFH Schoonbrood Variables Not Seen In Custom DataFlow Destination

  I have run into a HUGE problem (possibly a BUG)! I have a custom XML Destination script which uses a FILE Conn to send to another path using the original file name. (found in my foreach container (varFileNm) The problem is that my destination will not use the value found for the varFileNm. I can see the value just fine in the Flat File Receive, but I can't see the value in my custom XML Destinati ...Show All

• wjousts Can't connect to SSIS

  Hi,   I'm evaluating SQL server 2005 for planning a upgrade of our datawarehouse from SQL 2000 to 2005. We use a lot of DTS pacakages so that's my primary focus right now. I get this strange error when trying to connect to SSIS -> Stored Pacakges -> MSDB: TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For hel ...Show All