Hi I am trying to spool out to a CSV file using SQL Plus. The select statement I am using has paramaters &1 and &2. I have turned Echo Off but am still getting the actual SQL statements in my ...
Hi,
I have been using sql server 2000 for many months successfully importing a flat file into my dbase.
the file has naming data in row 1 before the real data begins in row 2. the last row...
I have a table in SQL that holds a list of values
COL 1
ROW 1 AAAAA BBBBBB CCCCCC DDDDDD
ROW 2 EEEEEE FFFFFF GGGG HHHHHHHH
ROW 3 JJJJJJJ KKKKK ...
I need to write a recursive query with the following conditions...I have a table called 'contracts' that can have 1 to may possible sales people attributed to it...each salesperson belongs to ...
I need to insert a text file from a web site using ASP.NET into a MSSQL 2005 table. The problem is that the website is on a shared host, and they will not give Bulk Insert Permission. Any sugg...
I am trying to do an update query in SQL 2k that updates a name field and removes only the pattern of space middle initial space. I do not want it to strip out any additional names in the fiel...
I have an Access database created in Access 2002 and we did a mail merge. We installed Office 2007 today and converted the DB to 2007 and get the following error when attempting to do the mai...
I have attached a code sample. One I execute the query and in the other I pass it through as an OLEDBCommand. Both ways an error claims that "Replace" is not a function. I am using Access 2007...
Dear EE community,
I've tried searching this site and Google for related solutions although I have yet to find one that works for me. So it's just as easy to write a new question I guess.
...
I am trying to import a comma delimited file (.CSV) into our SQL Server 2005 Database. I am trying to use BULK INSERT. The CSV file is a FEDEX report. It has fields such as "Mon, May 1, 2008"....
Hello -
I am attempting to migrate some DTS packages from SQL 2000 to SQL 2005. I have used the wizard and migrated them to a dtsx file and I am attempting to use xp_cmdshell when i run the...
I am trying to return all records ending in (h) or [h] from a table.
have tried using {escape !} and using *!(h!) in my where clause - but no luck.
have also tried ` and ' as suggested e...
hello, how do i insert a time stamp in oracle?
It seems that office 2007 (excel 2007) can no longer save files to dbase. I had been using this facility to create the field headers for dbase files. Can you suggest some workarounds? A utilit...
I have some very old software that was bought for my office years ago that uses Borland Paradox DB to store and retrieve information. Over ther years, the database has been corrupted and not ...
Computer A is contains main database file. Computers B, C, D, have shortcuts on their desktop to this file set-up through the network. I have also done this using drive mapping(with the same ...
Experts:
This is a tutorial. Tutorials are not supposed to be this difficult, especially "Hello World".
I have followed the instructions and created all of the classes, xml files, config ...
I need to be able to query the system tables to find all tables containing a specific column name
Something like select * from sysobjects where column_name = 'column_name'
I don't thin...
How can I fix 'Property not found (Error 3270)' ? in trying to run a query
Hi experts.
I am writing an overnight sync program from access to mysql using Access2Mysql Pro.
What I want to do is create a query in MSACCESS to show me all records modified in the las...
Hi!
I would like to generate a SQL query to find all duplicate records in my barcode file where each record of the barcode has a date range for valid date.
Say the table is the following...
My table contains records for timesheets. Each timesheet is analysed by consultant and can have several records, indicating the percentage allocated to each consultant (field "cons"). Table is...
with SQL Server 2005
When trying to
select col1, col2
into MyTable (on a local server)
from [developement.serverIP].devserver_DB.dbo.Base_Table
I am getting following error:
A t...
Hi,
I try importing data from an excel file using ado and vb6.
The problem is that excel the ms jet tries to analise the first 25 rows of the sheet and it makes some automatic conversions,...
I am trying to get a total unique number of click-throughs for given email campaigns. A unique click-trough being a unique URL clicked by a unique user. I need to be able to do this in a sin...
