You need to have a nested SELECT statement to return the maximum status end date and the Service Order Count by transaction id.

SELECT CRM_StatusCodes.TRANSACTION_ID

, MAX(CRM_StatusCodes.end_date) ...

For non-production environments, below are the SQL statements that I versus SQL Server 2000 where some minor modifactions to run under 2005 are needed (change the names of the 2000...

Regarding antivirus, there are a lot of files and directories that needed to be excluded when running a cluster.

http://support.microsoft.com/kb/822158 and http://support.microsoft.com/kb/250355

Antivirus software that is not cluster-aware may cause unexpected problems...

Welcome to three value logic, which applies when a column may be null.

Under two value logic, the expression if ( a = b or a != b ) is always...

High disk queue lengths are to be expected as these SQL Server operations...

From "Implementing Log Shipping" at http://technet.microsoft.com/en-us/library/cc917705.aspx

Because log shipping relies on the SQL Server restore process, user connections to the standby database must terminate each time the transaction log is restored....

If the machine were you are running SQL Server Management Studio does not have the needed fonts installed to view these characters, the data will be garbabled"

Do these appear correctly...

Use a single quote around the entire command and double quotes to delimit the start and end of strings.

exec master.dbo.xp_cmdshell 'dir "c:\program files\*.*" '

Book OnLine states that the FLOOR function returns the same datatype as the input but this statement is misleading because, for a NUMERIC datatype, the returned datatype is a NUMERIC...

As your table has four columns with the text datatype, you may encounter the situation described by the below MS information article, especially at you indicated that creating a copy...

Stored procedure msdb.dbo.sp_reassign_dtspackageowner can be used to change the owner of a DTS package but MS has hard-code logic to restrict the usage only to the current package owner or...

As others have indicated, the limiting factor is the load the applications put on the server. For example, I support a SQL Server 2000 that has over 6,500 databases...

Itzik Ben-Gan, a SQL Server MVP, has exactly the solution !

The problem involves calculating the maximum number of concurrent sessions for each application that an organization uses. For this problem,...

What are the advantages of this SQL over using the INFORMATION_SCHEMA views defined in the ISO SQL standard?

select *

from INFORMATION_SCHEMA.COLUMNS

WHERE COLUMN_NAME LIKE '%Employee_Id%'

Your post indicates a 160 GB HDD - is this a SATA, ATA, or IDE drive ?

In order to insure data integrity, the disk drive cache must be disabled or...