#1 - You need to figure out why it is erroring, and code the trigger to handle it without generating that error. Otherwise the error will cause the implicit...

The output file can be anything you want - it doesn't have to end with ".out". You also don't even need to specify an output file. Without one,...

I know BOL says that only one set of double quotes are allowed, but I just tested it with two sets and it worked fine. Here's what I tested:

...

I don't know a lot about ASP, but why not break the process down into smaller chunks, with one form per entity (driver, passenger, vehicle, etc.) For example, you've...

I don't understand your comment "if someone goes back and edits an NAV from several weeks ago - I need to change ALL the performances from that time forward." ...

I don't understand your question. If you mean how to resolve conflicts, use the Replication Conflict Viewer utility. Right-click on the database in EM and choose All Tasks...

Chris's solution works just fine. Maybe you didn't understand how to use it. The entire sequence you are looking for would be:

--1st chunk of 25000 rows

select top 25000...

DELETE tblCLTestScoresTEMP

FROM tblCLTestScoresTEMP CL LEFT outer join student_data_Main SD

ON CL.Permnum=SD.Permnum WHERE SD.permnum IS null

Jay Madren

Yes, the AND works with IN. What racosta was getting at is even though each criteria (predicate) returns records on its own, there are obviously no records that satisfy...

The CASE statement can only return expressions, not execute statements. It is intended to be used to return a value within a SELECT list. The IF..ELSE statement is...

Actually, in ASCII 13 is carriage return, and 10 is new line (or line feed). They're usually paired together, but have seen some systems/files use only one or the...

Another thing to note: The method I just posted compares the vaules as text strings. Don't use this method with between or < & > comparisons. Just use...

Cheddar's suggestion of CONVERT(VARCHAR, @date, 111) will do what you want. The statement would be:

SELECT * from table

WHERE CONVERT(VARCHAR, when_dt, 101) = '03/26/2003'

I changed the style parameter to 101...

The interpretation of '03/02/2003' depends on your server language settings. BOL say to use yyyymmdd format to ensure the same interpretation across all languages.

Jay Madren

It's not the SQL Server Agent that needs restarting. It's the merge replication agent, which is started by a job. To have the merge agent restart (or rerun)...