The "big one" from a performance perspective, that I see, is the query embedded within the SET statement, which is being executed for EVERY record the UPDATE statement touches. ...

I have to agree with SQLBill, as there are many companies that sell this kind of application and then "force" you into using their contracted services to do anything remotely...

While the OP's post indicates a result that includes the hour, I'm pretty sure the words he used preceding the result indicated he wants to eliminate the time part entirely,...

Take a look at the size of all the indexes in that database. It's quite easy for indexes to occupy far more space than the data itself. ...

I have to agree with the general sentiment here, that the managers, starting with Evelyn, completely failed to manage Eric, and avoided the one thing that could have made a...

Thanks for pointing that out. I wouldn't have recognized that as part of the problem. I'm not the OP, but it sure is good to learn...

Here's the solution for a single addressident:

DECLARE @ADDRESSES TABLE (

rownumber int,

addressident int,

vchaddress varchar(15),

datechanged DateTime

PRIMARY KEY(addressident, rownumber)

)

INSERT INTO @ADDRESSES

SELECT 1,1,'1234 park st','1-1-2000' UNION ALL

SELECT 2,1,'1234 park st','1-2-2000' UNION ALL

SELECT 3,1,'1234 park...

Robert,

Here's some simple code to demonstrate the results:

DECLARE @test-2 TABLE (

N int

PRIMARY KEY(N)

)

INSERT INTO @test-2

SELECT 199000 UNION ALL

SELECT 199700 UNION ALL

SELECT 199701 UNION ALL

SELECT 199702 UNION ALL

SELECT 199800 UNION ALL

SELECT...

Robert,

I stand by my post, as NOT BETWEEN 199701 and 199901 would never allow either of the stated values of 199701 or 199901 to meet the criteria, whereas simply placing...

There are several factors that can cause problems for Crystal Reports, or for any kind of database connection. First and foremost is your internet speed. Use...

Actually, the result of NOT BETWEEN and the previously stated pair of inequalities would be different.

1.) LTE 199701 AND GTE 199901 would produce no records, as it's not possible for...

If you're unable to change the table to allow null values for a given column, it's likely that there's an index that requires unique values for that column. ...

I now have an interesting problem with an Access 2003 adp file, based on my testing of the supposedly trivial conversion. My tables are all in a particular...

Glad you got it working. As to the file attachment, you might want to try specifying a complete path, including the drive letter.

Steve

(aka smunson)

:):):)

The ALTER would fail unless you also specified the code needed to tell it not to check the existing values. However, that wouldn't really solve the problem, as...