Answer Questions

• Jayender sivaraman http://localhost:8080 does't work??

  Im trying to set up an reportserver in my newly installed 2005-enveriment. But i can't get the report/reportserver to work when i brows to http://localhost:8080 i get an treestrukture off the website, but not the site Do i have to reinstall my reportserver or are there anyone who can help me It have been working, but suddenly it doesent I don't know if my applicationspolls are correct insalled either DEAR LUKASZ, THE ABOVE ERRO ...Show All

• sParc Cannot deploy data source DataSource to the server because it already exists and OverwriteDataSources is not specified

  When I deploy the reports I get the following warning Cannot deploy data source DataSource1 to the server because it already exists and OverwriteDataSources is not specified Is there any way of specifying Overwrite data source. Any suggestion is highly appreciated. Thanks I got that. Its in the properties of the report project... ...Show All

• Disconnected David Cannot Install SQL Server 2005

  I'm trying to install the final releases of Visual Studio 2005 Pro and SQL Server 2005 Developer's Edition. Unfortunately, I uninstalled VS Apr CTP "first"  INSTEAD OF SQL Server 2005 Apr CTP. I was then able to install the final release of VS 2005 without any problems but now I cannot install the SQL Server 2005 because it finds the beta components that must be uninstalled before proceeding. I tried using "Add/Remove Programs" but when I ...Show All

• ChuaWenChing "Not In" results set error

  I've got two tables with email addresses. I'm trying to return the result set from one when the email address is not contained in the other. Here's my select statement SELECT * FROM ITSJ_Pivot WHERE Email not IN (SELECT email FROM lists_master) Returns 0 rows Here are the results from the individual select statements for each table: select NUSOID from lists_master where email ='jon@lackeydesign.com' Returns 0 rows select NUOSID from ...Show All

• vije Errors in the high-level relational engine

  I'm getting an error when processing a partition - Errors in the high-level relational engine. The table_name table that is required for a join cannot be reached based on the relationships in the data source view. This table is actually joined to another dimension table, which is then joined to the fact table. How can I resolve this error Well, that might be the reason... To be honest I can't imagine a business case where you have a ...Show All

• Mattxxxxxx import from Access to SQL, not knowing the table format

  I need to import few tables from MS Access to MS SQL but the table structure in Access is always different, as I would like the destination table in SQL to be. Therefore I would like that a table would be created in SQL at runtime, according to the structure the Access table accessed has. OK, got the point. Just to be clear, I wuold like to do something like select * into <table destination> from <tab ...Show All

• Jim Selinsky UDF taking too long to run workaround ?

  I have written a UDF into which I pass a table name, field name, value of the field, whether alpha characters are valid, whether numerics are valid, and a string of alphanumerics that are valid. I return back a string with all invalid characters removed. Unfortunately when I use this on names and addresses in an 12000 row table, it takes forever to run. Can anyone think of an easy way to do this which isn't so labour intensive. Please see code b ...Show All

• Jahir Saleem Complex Query

  Hello, I am having trouble in getting the expected results. I have two tables as below. I need Idno,transdt,cd,cycdt,amt from joining two tables. The criteria is that if the transdt greater than same month of cycdt then we need get the next month cycdt and corresponding amount for that, if it is less than or equal to same months cycdt then get the same months cycdt and amt. Cd is dummy field which can be anything. I am using sqlserver 8.0 tab ...Show All

• lfx DataStage Vs SSIS

  Hi, We are in a process of migrating a process running in Ascential Data Stage to SSIS. The database server is ORACLE 9i. We need samples/guide on the following datastage equivalent features. 1. Calling a function/script/routine from task's Data Flow transformer as Before/After Stage event. 2. Complex XML parsing and loading into sequential files. 3. Creating a batch & based on the condition calling the tasks. For example, if condit ...Show All

• LittleSimon Adventure Works DB Samples with Express 2005 SQL Server

  Downloaded the file for the Adventure Works DB Sample. Which folder do I need to install it in to have show up in SQL Server Express 2005 did you get this to work I have attached the database and still could not get the report designer towork with the database. You can put it in any folder you want to (normally in the usual data folder you are using, by default this is located somehwere in the programe ...Show All

• Patrick Hampton Linked Server

  Hi, I have created a linked server using Excel file. When I run the query again this linked server, it works fine as I have all kind of authorities. But when user run it gives the following message (Queries are running from ASP.Net Page) System.Data.SqlClient.SqlException: Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "LPG". Here is how linked server is config ...Show All

• David Hayden CRL SP calling another SP and getting out parameters

  Hello All, Is calling another SP and getting out parameters supposed to work inside CRL SP via ADO.NET If I setup my command the standard way - a copy of the Quicksample code: // Fill the parameters collection based upon stored procedure. SqlParameter workParam = null; workParam = myCommand.Parameters.Add("@CompanyName", SqlDbType.NChar, 40); workParam.Direction = ParameterDirection.Output; myCommand.ExecuteNonQuery(); string temp = ...Show All

• Naqshekhayali Dynamic Connections

  I have read the posts on dynamic connections and still am not able to get it to work. Sorry, but I need specific instructions. I know it has something to do with the For Each Loop container, and something with the package variable, but I need more instruction. What I am trying to do is transfer data from several (86) servers to a central server (all SQL Servers). The many servers will have the same code run against them to gather data and tra ...Show All

• ink24 Quick Question Importing

  Two Quick Question's, Are you better off importing data through Excel or through Text files in terms of ease of use \ Speed \ Efficency etc or does it make a differance Also if I am loading data into a SQL database should I always use the "SQL Server Destination" rather than the "OLE DB Destination" Hope Q's aren't too basic, both seem to work for me, but I just want to make sure im using the right one. Thank you ...Show All

• andreas s order by in a view in sqlserver2005

  Hi, I've a problem with a created view in sqlserver2000 that I'm now using in sqlserver2005. This is the view : CREATE VIEW hsarti01_VD1 AS SELECT TOP 100 PERCENT * FROM hsarti01 WITH(index(hsarti01_PK)) ORDER BY 1,2 desc,3,4 When I do the "select * from hsarti01_VD1" in sql server 2000, I see in the result that the order by is been using. but in sql server 2005 it's just using the order of the primary key and not the orde ...Show All