Can't you just join the tables?

SELECT a.Audit_Date, SUM(a.Audit_Total_Units) AS TotalClaims, SUM(ISNULL(e.Error_Unit_Count,0)) AS TotalErrors

FROM Audits a LEFT JOIN Audit_Errors e ON a.Audit_Id = e.Audit_Id AND e.Error_Type_Id = 6

GROUP BY a.Audit_Date

ORDER BY...

http://www.sqlservercentral.com/columnists/awarren/bypassingtriggers.asp

<quote>With the /3GB switch and no modification to max server memory, will SQL Server still be limited to 2GB of memory?</quote>

No; SQL Server 2000 EE on Windows 2000 AS will...

You cannot do this wthout changing the SQL statement as written because, without quotes, the word True will be seen as an identifier, not a value.  Unless SQL is written...

Perhaps something like this:

SELECT cl.ID, i.SumRsvInd, e.SumRsvExp

FROM dbo.CL cl

 JOIN

 (SELECT t.ID, SUM(c.Rsv_Indemnity_Amt) SumRsvInd

  FROM dbo.ClTransaction t JOIN Code_Value c ON t.Transaction_Cd = c.Code_Value_Id

  GROUP BY t.ID) i ON i.ID...

I know nothing about Access, but here are some good tips:

http://www.sql-server-performance.com/visual_basic_performance.asp

I also suggest reading Andy Warrens Introduction to ADO articles on this site.

Your default collation is not for binary sort order.  Try:

WHERE MyLastNameField BETWEEN CAST(CHAR(0) AS char(1)) COLLATE Latin1_General_BIN

 AND CAST(REPLICATE(CHAR(255),60) AS varchar(60)) COLLATE Latin1_General_BIN

or:

CREATE TABLE MyTestTable(MyLastNameField...

You could use an INSTEAD OF trigger and check the text column(s) using IF UPDATE() and then joining the table to deleted on the primary key and sending the text...

Yes.  Full (and differential) backups are independent of the chain of tran log backups.

Yes.  If the tran log has not been backed up since before the desired point-in-time, back up the tran log.  Then restore yesterday's full backup and its previous tran log backup...

You do not need to reinstall.  See the Renaming a Server topic in BOL.  Plus, perhaps, this:

http://support.microsoft.com/?id=303774

WHERE ISNULL(SUBSTRING(a.TexrCol,DATALENGTH(a.TextCol)),'~~Null~~') = ISNULL(SUBSTRING(b.TextCol,DATALENGTH(b.TextCol)),'~~Null~~')

quote:

---

On a side note, there was the utility unitomp (???) to upgrade NT4. When I set up Win2003 I ended up reinstalling...

As you were planning to include the password in your connection string anyway, why not just use an application role if there's only one database?

--Jonathan

quote:

---

Jonathan

I am looking at your SP and trying to understand it. Is there any documentation on spt_values? I can't seem to...