I wonder how many people use them?

Start with the first join and see how that goes

SELECT TOP 100 *

FROM S_OPERATION, S_FILE_NUMBER FNUMBER

JOIN S_CUSTOMER SENDER

ON S_OPERATION.SENDER_ID = SENDER.C_CUSTOMER_ID

Are you trying to join 2 tables S_OPERATION and SENDER?

Then...

You can use substring in SQL 2000

Here is an example:

declare @fg char(100)

set @fg = '0xF60F9125DBA7E94012F55E2177C95C0E906862B1'

select @fg

select substring(@fg, 3, 98)

This article explains how to transfer users between instances.

http://support.microsoft.com/kb/246133

Thanks Nadrek for your response. It was my understanding that RAID 10 is superior over RAID 5 on writes. However; using the same number of hard drives, RAID...

Gregory, great article

But I have a question about read performance for RAID 5 and RAID 10. In your table you showed that RAID 5 scores Good and RAID 10...

The self join is working just fine. Thanks for all your help.

I don't think the transfer did happen since it is only 5 minutes difference between the 2 registrations and the nurse station didn't change but it may work for me...

That is exactly what the 2 extra columns are; the registration date and the next earliest registration time to the new nurse station. The problem I am having...

ckelly

Where did you get the screen shots ? It doesn't look like SSMS

Yes, it makes a lot of sense to separate the data and log files on different logical drives.

http://technet.microsoft.com/en-us/library/bb402876.aspx

Dave

Your example works a lot faster

Thanx

Sorry Dave

The link doesn't open

You can use datediff to skip the hours

SELECT ExamsId ,DateOfExam , PAPERNAME,

FROM TBLEXAM

WHERE PAPERID =2 AND datediff(dd,DateOfExam,GETDATE()) = 0

Is this what you are looking for?

DECLARE @agenttime TABLE

(agenttime DATETIME)

INSERT INTO @agenttime SELECT ('2011-09-05 12:12:01.000')

INSERT INTO @agenttime SELECT ('2011-09-06 12:12:01.000')

INSERT INTO @agenttime SELECT ('2011-09-04 12:12:01.000')

SELECT...