Yes, it's not a data quality issue. The problem is related to the way SQL Server is handling the validation rules that were setup in access. Here's an example.

this statement:

insert...

Thanks for your reply.

I'm not sure an index on SendNews would help, because it only contains 1 of 2 possible values ('Y' or 'N').

I guess this is the problem...

here's what i did, it seems to work correctly, tho i'm not overly happy about loops:

WHILE @pi_dStart <= @pi_dEnd

BEGIN

IF (DATEPART(dw,@pi_dStart) NOT IN (1,7))

SELECT @iNumDays = @iNumDays + 1

SELECT @pi_dStart =...

ah great, so its just like a regular WHERE statement.

thanks for your help!

Sincerely,

Matthew Mamet

Web Developer

embarc LLC

http://www.embarcgroup.com

Greg, thanks for your reply.

I should have been more specific in my original question, because the help I need is how to change the ON clause of the join to...

The problem came about when we installed Full Text search on SQL Server 7.0 after we had installed SP4.

Re-installing SP4 fixed the problem.

quote:

---

Here's a really slick control that'll do the trick and more!

http://www.softartisans.com/softartisans/excelwriter.html

---

for 800...

if you and steve could spend some time on this issue, i would greatly appreciate it.

well, its not the answer i expected because we've found that 1 mega server is...

honestly, that was not the answer i was expecting, and i'm kinda surprised.

but more importantly, is there any documentation/white papers out there that discuss this kind of thing?

The exact syntax is:

SELECT field_names

FROMtable_name WITH (INDEX = index_name)

ORDER BY field_names

what's BOL?

ok, i'll bite.

How??!?!?

visual interdev?

really?

where is it, how to use it?

ok, i solved my problem. here's what was going on (if anyone's still interested! :P)

there was actually two errors.

the first error was a simple pk_violation error occuring somewhere deep...

ok, you didn't give a whole heck of a lot of info, but here's a suggestion.

Rather than add a column to a table to store IP counts, use a separate...