Hey folks,
I need instruction on how to run a query wherein I can "exclude" entries from a particular column. I need to run a query to pull voters from an existing table, but, I need to exc...
Hi,
Extension of question from http://www.experts-exchange.com/Database/Miscellaneous/Q_23580695.html
Now I have a table:
Num ID
---------------
1 123
2 123
3 123-X
4 8...
I have a table like:
id date name
1 10:10 Marius
2 10:20 Marius
3 10:30 Marius
4 10:30 Cosmin
5 10:55 Cosmin
7 10:20 Alex
8 10:...
I have two databases on the same Microsoft SQL 2005 server (test and production). Each night I run a 'copy production db to test db' job so the test db has production data in it (requested by...
This would be for use with MS Server 2000 and DB2:
Would like to maintain a table of integer counters, one record for each counter. As an invoice, order or whatever is generated, I need to ...
Hi Guys,
I am trying to dymamically set the default value for a primary key field on a SQL server table linked via ODBC in MS Access front end.
This worked perfectly in previous version I ...
Ok, I am not to informed on all the definitions of what I have been doing but here it goes...
I have an old outdated database that has stored attachments as either OLE or BLOBS? (This is wh...
In my MS Access database, I have a TableA, TableB, TableC, all of which have a common field FieldCommon. I want to get FieldB from TableB, by joining with TableC (based on FieldCommon) and up...
Greetings!
I have a thrid party application that is designed to execute stored_procedure that accesses "views" from an oracle database in order to collect customer data.
We have a SP tha...
I have a small Access database that is used monthly to analyze invoice data that is received as a CSV file from one of our large vendors. I have created a import routine that allows the user t...
I've got a stored procedure that rebuilds a datamart every night from tables in another database on the same MS SQL Server 2000. The procedure works fine but the log file gets pretty big prett...
I created an auto-increment sequence on column id of a table with start value of 1 and step of 1. Assumed I've insert 5 rows in the table. The id is 1,2,3,4,5. Now I delete one row, for exampl...
Hello there good people at Experts-Exchange!
I've got a Microsoft SQL server sitting on an Active Directory. One of the database team have requested that a user from a different (NT based) ...
Hi There,
WINDOWS Environment but can use a UNIX machine if needs be.
I have two db dump text files I need to append and merge.
So, what I need to do is as follows.
I have an ori...
I am trying to run a query against two tables. Table 1 contains a field called "Category". Table 2 contains a field called "Description". There is a field called "GB-ID" which links these t...
xp_cmdshell 'dir c:\'
xp_cmdshell 'whoami'
xp_cmdshell 'hostname'
xp_cmdshell 'which hostname'
All the above returns NULL. It is a SQL Server 2000 box. I am running it from a query analy...
Dear everyone!
m having problem with inserting image to mySql. I use Java language, JSP, Hibernate,,, I see a lot of solution dealing wit this problem but ont wit Hibernate, only with Prepa...
Hi!
After upgrading a economic system from MSDE to SQL Express 2005 database server, my customer has problems with unstability. The system runs slow from time to time. The new installation ...
I have view in t-sql(2000).In that view,I have all columns in the base table and 2 extra columns which extracts fromdate and todate from one of the column(varchar) from basetable.Those columns...
I'm trying to import a log file into sql 2005 using bulk insert command.
The file is spaced delimited,
My problem is that I have data that is warp with double quotations marks and inside I h...
Hello,
This is what I have in place:
1) The forename and surname of the Windows logged on user in a string.
2) I have "split" the string in JavaScript to get the forename and surname se...
I'm in no way a programmer - I've managed over the last few months to find some code which works very well - to attach files which are named within an Access Database - with email address etc....
Lets say I have the following CTE expression:
WITH TopSales (SalesPersonID, NumSales) AS
(
SELECT SalesPersonID, Count(*)
FROM Sales.SalesOrderHeader GROUP BY SalesPersonId
)
SELECT ...
Hi,
I am writing a football league system using Microsoft Access. I have two tables:
tbl_teams : TeamID,TeamName
tbl_Fixtures : HomeTeamID,AwayTeamID,FixtureDate
I have been trying t...
Hi,
I am writing a program to read a sql file containing multiple queries and executing it in my C# program.
I wanted to know what would be the best way of doing this. I am currently separat...
