Answer Questions

• smaynard123 SQL Update statement

  Hi all, Sorry for this super newbie question, but I am purely a mysql developer. I am trying to update a table using Query Analyzer and am having problems with the sql syntax. This is what I'm trying to do: update table set column1 = 'test data', column2 = 'test data2' where column1 is NULL and column2 is NULL I receive 512 errors, stating that the subquery cannot return more than 1 record. I understand that most of the table has ...Show All

• mark duran New RDL Spec differences

  Is there somewhere that explains the major differences between the 2003 RDL spec and the new one released in November I will be going through the two specs in detail in January looking at the differences but I was just wondering if there's a quick synopsis out there somewhere. Are there any major differences Darren #10 DataValue element: if you check the underlying XSD, you will see that there is only on ...Show All

• AmolB SQL multiple instances

  May I install multiple SQL Server 2005 Instances on one disk (Example: J drvie) Sure you can. Thanks Jens. What is the performance for one disk hold multiple instances vs. one disk hold one instance (multiple instances on multiple disks) ...Show All

• lekem SSIS job cannot find file....

  I'm getting an error when running my SSIS package in a SQLAgent job.... Message Executed as user: DOITLHHQSQLT01\SYSTEM. The process could not be created for step 1 of job 0x35D6B42101FB6646B20036599D407110 (reason: The system cannot find the file specified). The step failed. This is the command line executing the SSIS package.... /SQL "\ES Packages\ES DEDUCTIONS" /SERVER DOITLHHQSQLT01 /MAXCONCURRENT " -1 " /CHECKPO ...Show All

• michels MS SQL Server 2005 64 bit CTP:[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

  I am facing a problem with SQL Server 2005 64-bit CTP June 2005 on Windows 2003 64 Bit. When i try to connect to the SQL Server Instance using any of Windows/SQL Server Authentication from My Application using SQLOLEDB interfaces (From Win32 Code) it is not able to connect and throws following error: " [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. " When in the same code I use SQL Native Client ...Show All

• Koos Brandt Trouble inserting multiple nodes during UPDATE

  I am trying to insert multiple nodes to an xml column using an update statement from a joined table.  For (a simplified) example: UPDATE     Documents SET     DocumentDetails.modify('insert <DocumentParty name="{sql:column(''n.Name'')}"/> ...') FROM     Documents d     INNER JOIN DocumentNameXRef dnx        ON d.DocId=dnx.DocId     ...Show All

• rima IDENTITY fields

  I have a table with an IDENTITY column for a pkey. I'd like to insert one record into this table and use the generated identity value to insert ~100,000 rows in a second table. I'm sure this is a common scenario. I don't want to pre-generate identity values or anything like that - it seems like this should be a simple task and I'm missing something. I've tried OLE-DB Command tasks with INSERT INTO ....; SELECT SCOPE_IDENTITY() - ...Show All

• BAnVA Having Problem With installation

  Hi: I have already installed QSL 2005 on a win 2003 machine. The installation was without erroe or something but when I open services I do not see any sql in there and when I open the management interface there is no machine detected there. Would you please help me to run this software. When in the management tool I try to connect to the server this is the error I get: An error has occurred while establishing a connection to the server. W ...Show All

• anuppm SQL Server does not exist or access denied

  Hi,  I have developed a small application using VB6 on Windows XP. Following is the code snapshot. I have added Microsoft ActiveX Data Objects 2.1 Library through Project Reference for ADODB Connection. Public con As New ADODB.Connection Public Sub Main()     Set con = Nothing     With con        .CursorLocation = adUseClient        .ConnectionString ...Show All

• Steve Hudson Resolve conflict

  Hi, l've a raw data which contains list of device name and # of wires used, i.e. DEVICE NAME # of Wires --------------------- ------------- A 10 B 11 C 17 D 5 A 0 E 0 So l would like to import these data into my table (with device name as primary key) which each device only appear once. If the device name appear ...Show All

• nvierros Concatenate text with expressions?

  Hello, I have a textbox and I want to concatenate my text with some value from the datasets, I have tried differente syntax but nothing De acuerdo con & Fields!NombreEvaluando.Value De acuerdo con & =Fields!NombreEvaluando.Value Thanks Try "De acuerdo con " & =Fields!NombreEvaluando.Value Stan Expressions start with "=". Use ="De acuerdo con " & Fields!Nombr ...Show All

• Christian Bayer Is this impossible?

  SQL Database ID   TypeOfReport    Report    DateOfReport   I need to select a Type of Report, first by UserInputDate and then by all other dates The problem lies in... there may be dates > inputDate and < InputDate and I don't know how to  do it with a single SELECT statement.  I know it's easy to select report by UserInputDate and then do another query by All dates <> ...Show All

• Geof2323 Identity column not returnd after AddNew / Update with ADO and SQL 2005

  Hi, I add new records to a table with ADO. The tables contain an auto-increment identity column. I want to retrieve the identity value after the insert operation. This works fine for SQL Server 2000. On SQL Server 2005 this only works if I use a table in the select statement. If I use a view in the select statement, ADO returns no value for the identity column, a trace with profiler shows that there is no Select @@IDENTITY statement. What ...Show All

• Karthik987 Stop user access to load the datamart

  Hi We are running a pilot with RS 2005 on a datamart. We load the datamart every two weeks after the payrun during work hours. What is the best way to prevent the users from using Report Manager and running reports during the time when we are loading the datamart Thank you. ...Show All

• Aner Coverting Int to DateTime Recommendation?

  Friends, I have a database that I am in the process of converting to a new application. All the dates are currently stored as an numeric YYYYMMDD format. I am hoping someone can suggest the best way of dealing with these in SQL Server. Should I convert them to DateTime formats for example, and what is the best way to do this Any input would be greatly appreciated. J.H. yes you should do it. the bes ...Show All