That is odd, maybe if you analize the problem like this, you'll find that your duplicates aren't really duplicates

 

select 

CaseAll.caseno,

CaseAll.fname,

CaseAll.lname,

CaseAll.date,

file30.reportid,

file30.caseid 

from 

(

select 

Case30.caseno,

case30.fname,

case30.lname,

case30.date

from Case30...

It is really a curiosity. BTW in mssql 7.0 won’t happen this.

'Sort', and 'Sort/TopN Sort' may be different.

In mssql 7.0, first is always a SORT proc, then a...

Totally agree, IN may use indexes (not in 6.5 or earlier), only in a simple case, and NOT IN will not.

But, as a good practice advice : EXISTS and NOT...

I preffer this:

sqlSTMT = " Select * from tableName where exists ( select * from tempTable where tempTable.Id = tableName.Id ) "

(In old Mssql...

There is no way to avoid the use of the log. Your 'not so temp' tables may be better in a small, auxiliary database with the trunc. on check point...

Apparently corrupted LSN information is involved in this problem. Resetting its value in the log reader may help, if more simple causes are discarded (cpu overloaded by other services, slow...

The query is a good start point for the analysis, but it would be useful simple verifications such as: compare the data of the tables in the query, a simple...

Then use simple quotes in you @strsql.

(to include a simple quote in a simple quote delimited string, type it twice

@strsql = 'SELECT distinct field FROM table

WHERE field LIKE ''Ob_L%0'' ...

First I think you should check out AdoDB.Stream class and examples for updates/reads in text fields

Second, avoid transactions!, you have many ways: autocommit=true for example. Because transactions will impose limitations...

Easy solution: include your users in 'db_owner' standard database role.

Could try with 'ddl_admin' insted.

Of course 'db_datareader', 'db_datawriter' is a must for this users.

ps: And also could avoid creating tables 'not...

Maybe the parser and the bug are incorrectly assuming that datime1>’yyyy-mm-dd’ requires the datetime data type to be converted to a string (a varchar, for properly SQL speaking).

Would you...

The SQLServerAgent and the MS SQL Server itself, runs on your NT as a 'service'.

A service sometimes requires a NT ACCOUNT to run properly (not a SQL account) because...

/*

This is the way I use: For example, pub..authors, order by au_lname from the 6th to 10th row.

I use a Java static funcion to generate it for my JSP search...

This wil work fine,

select a.nrow, avg(a.royalty) from

(select (select count(*)+1 from titles as aa where aa.id < xx.id )/10 as nrow, * from titles as xx) as a

group...