You are correct, sir. Time to email someone.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

I would hope the without should have been with. Running without a password isn't smart, even in development. There's even been a worm developed to exploit this.

K. Brian...

The datetime data type is going to store the milliseconds, it's part of the data type. However, if you want to eliminate milliseconds, you might want to do something...

Yes, you can install SQL Server 2000 on a laptop. My personal machine is a laptop and I've got Developer Edition (MSDN) running on it as we speak.

As for...

Triggers in SQL Server 7 and AFTER triggers in SQL 2K do not support text or ntext data types. INSTEAD OF triggers for SQL 2K do. Here's more:

http://www.sqlservercentral.com/columnists/bkelley/triggerswhatsnew.asp

K....

I've had to use multiple collations on a couple of occasions (certain apps we run use binary sort order) and have not run into any issues. However, I've been...

The information is stored in the system tables, but Microsoft reserves the right to change them at any time. The Information Schema views are mandate by the SQL-92 standard...

Glad to be of service.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

What happens if we replace AVG(MyID) with AVG(CAST(MyID AS Decimal(9,2))) to ensure SQL is averaging a decimal value?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

Paul and I are thinking along the same lines:

SELECT ET.*

FROM cmsEmployeeTime ET

JOIN cmsEmployee E

ON ET.EMPTIM_EmployeeID = E.EMP_EmployeeID

LEFT JOIN cmsEmployeeTimeCompare ETC

ON ET.EMPTIM_EmployeeID = ETC.EMPTIM_EmployeeID

AND ET.EMPTIM_DateWorked = ETC.EMPTIM_DateWorked

AND ET.EMPTIM_WorkPlan...

Are you looking for an identical match across all fields or are you just looking for a match based on primary key? If it is a match on the primary...

If you are using SQL 7.0 or 2000, Profiler can be your best friend. I've gotten burnt the same way and the next time after...

The way this is written, the only way the where clause is going to evaluate to true is if there are no records present in (select * from cmsemployeetimecompare). ...

Another approach:

DECLARE @n int

DECLARE @sql nvarchar(255)

SET @n = (SELECT COUNT(*) FROM MyTable)

IF @n % 2 = 0

IF @n = 2

SET @sql = 'SELECT AVG(MyID) Median FROM MyTable'

ELSE

SET @sql = 'SELECT...

Having NULLs doesn't bother me all that much because of my mindset from my academic background. However, I'm not necessarily comfortable with fields going empty or filled with dummy...