I need to import data from A To B ,There is 3 option to choose the "import type" (1) I choose option 1, all data are imported succesfully BUT there is no SP (2) so I choose option 3, imports all object , sp , and some scrpits Finally, I got an error, it said 'Failed to copy objects from Microsof...more >>

I have an application on a laptop that runs with several ADO objects open at a given time (Connection, Recordset etc) - most all use client side cursor. The database is on another machine. If the application is running (sitting idle) and the laptop goes to sleep and then resumes, all the a...more >>

I have a tblMember table with a fldFirstName field. I have now added a fldNickname field to the table. Is there a SQL command I can run (without writing a TSQL stored procedure) which would copy values from the fldFirstname fields of existing records into the fldNickname field? ...more >>

Hello, when I use SELECT getdate() my result is 11/26/2004 13:38:42 What do I have to set to become only the date like 11/26/2004 00:00:00 Thanks for any help in advance Andreas Klemt ...more >>

Hi, I have this procedure: ALTER PROCEDURE WS_Carrier_GetAutoQuoteListByServiceTypeID ( @ServiceTypeID integer, @ShipperID integer ) AS Select * From CarrierAutoQuotes Where ServiceTypeID = @ServiceTypeID AND (ShipperID = @ShipperID OR ShipperID = 0) AND Enabled = 1 ...more >>

Hi NG, I've to copy data from one row to another within the same table: Example: Row with ID=2 (Type=3) gets the value of row one (Type=3) ID; Val; Type 1; 4711; 1 2;4711; 3 Do I need an intermediate statement or can I do that within one SQL Call? thanks for support ...more >>

Hi all, I have run into a problem when executing a stored procedure that has got me totally stumped, and I hope that some here can help me out. The senario is that I am populating a set of fact and dimension tables to be used by an Analysis Server server, to enable parameteristion of the ap...more >>

Hi... A much lamented question, I guess.. I'm trying to create a simple audit trail. log the changes to an SQL 2000 table, so that they are written into a mirror table. The entire record, only the updated one, i.e. if say only one field changes, the audit table will be inserted with one rec...more >>

The statement alter table people add persname as CoalesceEmpty(nickname, firstname) + ' ' + lastname returns Server: Msg 195, Level 15, State 10, Line 1 'CoalesceEmpty' is not a recognized function name. CoalesceEmpty is described in the documentation as an "MDX function". What is...more >>

Hi again, I know expression dialog will be changed, I want also suggest: there is replace, insert, append button, nice would be copy to clipboard. Now I must append field, cut it, and paste it in right place_s_. -- Ing. Branislav Gerzo...more >>

Hello, I need to transfer (copy) and transform data from one database to an other database. Now I have hear about ETL tools, maybe someone here can give me some advice. What is a good, easy to use and graphical, ETL tool? Do you know the name or internet address? Thanks! ...more >>

Hi everyone, I've got some strange problem, I need to import file from Filemaker Pro 5.5 into SQL Server database,using dts package and I'm getting error: "An attempt to fetch forward has failed for table:XXX. Unknown error. Error in row. Context: your provider doesn't support all interfaces/...more >>

I'm looking for a book(s) that will detail how to develop in both SQL Server and Oracle for the same application. The two-three web page will not do the trick. I did the bitter details. In particular, I need to find out how to return a result set from a stored procedure in Oracle. ...more >>

Here is some sample data. ID INITIAL NAME SEX HIREDATE STATDATE STA ACT REA ENDDATE 123456 AA SMITH M 19680513 19680513 123456 AA SMITH M 19680513 20030115 A 123456 AA SMITH M 19680513 20030215 A 12345...more >>

Im trying to set up a Backup Maintiance plan for one of our SQL 2000 Servers. Using Enterprise Manager i create the backup job, but when trying to run the Job, it fails with the following error; 'The Job failed. the Job was invoked by User sa' Any Idea's as to why the jobs are failing...more >>

How would one go about selecting from a table, which is a variable ? The following query doesnt seem to work: DECLARE @TableName varchar(255) SELECT @TableName = 'Table1' select count(*) from @TableName1 Will i need to build up a SQL string and exec it? thanks, Justin ...more >>

Hi, below are 2 queries as a proof of concept. The query represent a real-life situation in which there is a sortclause based on 2 fields with the same name in 2 tables. The SQL is generated. Query A: SELECT customers.CustomerID as customerid, customers.CompanyName as companyname FROM...more >>

When I run a query on my database teh datefield retunrs a format 2004-11-26 while I require it to be in a format 2004-11-26 for specific interface I am writign using DTS. I do not want to change teh database date format - How in a normal select query can I cange the display format of this date fi...more >>

create table testVisit ( VisiID int identity(1,1), UserID int, VisitCount int, VisitDate Datetime ) insert into testVisit (userID, visitCount,visitDate) Values (1, 1, '01-01-2004') insert into testVisit (userID, visitCount,visitDate) Values (2, 1, '01-01-2004') insert into testVisit (userID, v...more >>

[Apologies for earlier post - twitchy trigger finger!] I have a VB6 application that links to an SQL Server 2000 DB (via ADO) I recently had to change it to add a date field to one of the features, which although it worked on my development machine, it wouldnt work on the live system. I norm...more >>

Can you tell me if the SQL Server Ce 3.0 is available ? Thanks Marc ...more >>

I have a VB6 application that links to an SQL Server 2000 DB (via ADO) I recently had to change it to add a date field to one of the features, which although it worked on my development machine, it wouldnt work on the live system. I normally format my dates for SQL as follows: YYYY-MM-DD, and...more >>

Hi I just want to know how does it work when SQL runs stored procedures. When I run a procedure, halfway during the run of that procedure I alter it with some other content, will I get funny results. As far as I know, when it's executed an instance is create of it in memory, and that sp...more >>

Hi All, I am trying to pull data from a table which tracks each time a user runs a report. I am trying to retrieve a users TOP 5 most frequently used reports. However, I would like the TOP 5 that are retrieved to be distinct. What I have posted below pulls the TOP 5 but it retrieves duplic...more >>

The SQL below produces the following result set... SELECT PARTNUMBER, i.LINE , COUNT(*) AS BUILT FROM INVENTORY..V_BC i INNER JOIN INVENTORY..VALID_LINES v ON V.LINE = I.LINE GROUP BY i.PARTNUMBER, i.LINE PART LINE BUILT -------------------- ---- ----------- 1282...more >>

ALTER TABLE mgadr DROP PRIMARY KEY Incorrect syntax near the keyword 'PRIMARY'. why????...more >>

HI FRIENDS!!! I HAVE THE THESE TABLES: -------------------- CREATE TABLE [TBL_SaldoDiario] ( [T_Data] [datetime] NULL , [T_Saldo] [numeric](18, 0) NULL , [T_C_ID] [smallint] NULL , [T_ID] [bigint] IDENTITY (1, 1) NOT NULL , CONSTRAINT [PK_TBL_SaldoDiario] PRIMARY KEY CLUSTERED ( ...more >>

SQL Server 2000 Sp3a, Windows 2003 In the morning, I have a rather invokved DTS package that runs (It imports a huge flat file and then does several INSERTS/UPDATES with other tables that are in the 50,000 row size) At this time in the morning no one else is using the database. The DTS ...more >>

Hi I am looking for a stored procedure tutorial somewhere on the web. Ideally, it would propose best practices for select, insert, update and delete proc. It would also show error handling. All this in a 30-40 pages document easy to read. Please help me find this jewell. I have already looke...more >>

Hi, Please select how to put row data in a single column with a delimiter. For example consider the following data Col1 Col2 AAA A AAA B AAA C BBB D BBB E CCC F DDD G The data should be presented as follows Col1 Col2 AAA A;B;C BBB ...more >>

Hi, We use bulk copy (bcp) in a large Swiss Social Insurance Project to import data from different other software systems. The 'other' Programs have to provide data in a ascii file for bcp. (Something like: D;A;1;567890;0;702;378;Lastname;Firstname;20070511259;19700111;F;3;CH;1; ...... ...more >>