Microsoft SQL Server Forum

Hi: I got an error message when I am trying a select Query to import a table from Ms Access Database (.MDB File) in SQL Server 2005.i am using SQL Server 2005. The query I am testing is as below: SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source="d:\Test.mdb";pwd=XXXX')...Employee The error message: OLE DB provider...

Hi, I'm trying to write a Group By query. I have a table that looks like this: label value version Fee 25.99 5795 Term 3 5795 Terminated 0 5562 Terminated 1 5563 Terminated 0 5794

I am a Beginner of SQL Server. 'm using SQL Server Management Studio. I'd like to know how can I avoid duplication in a Column other than Primary key. B'cuz I used a primary key in another column. eg. ID Name Age ---> Columns -- ---- --- 1. ID is Primary Key, 2. I don't want to enter the same name again,

Hi, I am using an order by on a standard Insert .. Select into query. It is listed below. When I put an order by into the select statement, it gives an error of 'Incorrect syntax near the keyword 'order'.' However, if I remove the order by it works fine. If I run the select statement by itself, it works fine. Also, eventhough the records...

Hi, I have a table with these values: ========================================= column1 column2 column3 firstname 462 david lastname smith NULL =========================================

How can i add below 4 field in Existing stored procedure ? DECLARE @StartTime datetime DECLARE @CurrentDate datetime Declare @Days int Declare @Hours int Declare @Minutes int declare @Second int SET @StartTime = EmployeeTempAttendanceDetail.EmpInTime SET @CurrentDate = EmployeeTempAttendanceDetail.EmpOutTime

Hello, how can i send db tables as an xml format to my customer. In ssms there is an icon as 'Results to file' & when i right click on this i checked(checkbox) on XML Editor but my o/p window is empty. how can i acheive this ? can anyone please help me out in this regards. thanks, nav

I need to execute one procedure automatically using timers in mssql. for example everyday it will executed automatically at the 12:00 00:00:00:000. Give me some codes for that...

how to find the data type of a fild in a table.......................................

I have a maillist table which contains usernames of my entire membership list. Another table (Registry) has username as a foreign key. I am doing a checkbox form that reads from an SQL Server database and I don't want to have names on the checkbox list which are already included in the Registry table, because these people have already registered....

Hello , Can any one assist. I have a Street Address file and i want to split the information in the file into different columns. For example "100 SW 14th Street N, Suite 120" First. The script will capture the 100 into a new column called StreetNo. Was thinking of a scenario where the script does a count until it finds a space then stops....

I need help to make this procedure copying file works for me. The error is Msg 50000, Level 16, State 1, Procedure sp_copyfile, Line 23 File copy failed USE GO /****** Object: StoredProcedure . Script Date: 12/20/2011 10:37:44 ******/ SET ANSI_NULLS ON GO

Can anyone provide me the step by step instructions for Converting all the database from SQL server 2000 to SQL server 2005. I have an application that is not been used at all and the whole thing needs to be updated to sql server 2005. Please tell me what all things need to be done including the VB code as well and the database migration.

I have columns H,I,J,K,L,M in excel and a column M is the sum of (H,I,J,K,L)in excel but if I want to import the excel data to SQL how can I acheive this functionality. Also for each of the columns H through M ,I need the total at the end. eg: H I J K L M t1 t2 t3 t4 t5 (t1+t2+t3+t4+t5) tt1 tt2 ...

i have created on table Customer which have column as primary key and IDENTITY(10000000,1). What i want is how can i insert values for the table using INSERT INTO Customers values(<values>) query Be cause it generates "An explicit value for the identity column in table 'Customer' can only be specified when a column list is used and...

ALTER PROCEDURE . @LeaveApplicationId int, @LeaveId int, @EmployeeId int, @LeaveApprovalFromDate datetime, @LeaveApprovalToDate datetime, @LeaveApprovalHalfDay bit, @LeaveApprovalApplicaitonDate datetime, @LeaveApprovalDuration numeric(18,2), @LeaveApprovalDate datetime,

Hi, This is with regards to the RDLC Subreports. Here is what I tried - on the form load 1) attached the handler with the event subreportprocessing 2) loaded the subreport definition 3) Inside subreportprocessing handler, added a datasource

Total newbie here, many apologies if I have failed to find an extant answer to this question. Using: SQL Server 2000 I need to restore several hundred databases from an external drive to local drive. Would like to batch, eg, call on a text file listing old and new db names/paths and loop through to end of text doc. Currently have...

;with cte as ( select empid, cast(datepart(hh, logtime) as varchar(2)) + ':' + right('0' + cast(datepart(mi, logtime) as varchar(2)), 2) as logtime, row_number() over (partition by empid order by logid) as row from #timing ) select c1.empid as EmployeeID, min(c1.logtime) as InTime, max(c2.logtime) as...

I want to restore backup from mapped network drive which i have shared in MSSQL server 2003. I have mapped a network drive & given sharing to the folder. I am using a batch file to restore it...contains of the file is as below : SQLCMD -i RESTORMIS.txt -o RESTOR_outpu.log and RESTORMIS.txt contains as below : RESTORE DATABASE PRODRDCC FROM...

I hope you can help me. I am trying to generate a report using 3 tables - sttakehm, sttakedm and stquem. I wrote below query but it is giving all values of unit_cost, I only need the unit cost which matches stquem.sequence_number=sttakedm.queue_reference and adjustment quantit. The key is sequence number is in one line with Kind = "C"...

For Example I have Table name called "tbl_certificate" Fields as follows id Certificate name 1 Secondary 2 Highersecondary 3 Undergraduate

select stuff((select ','+ from <TableName> for xml path('')),1,1,'')

We have two systems on developed in .net running off a SQL back end. We have a second data table in DB2 running a whole separate system. I need to dynamically copy data from the ms SQL table to DB2 how can I do it any suggestions?

Hi I am trying to get my query to work in my middleware which piggybacks off of the mssql driver using jdbc. Anyway, The query gets this error when i run in it the middleware ERROR: Failed to create input and/or output schema(s): "Duplicate field name found 'NAME', please modify the query and create unique aliases for duplicate fields"" The...