This is the create DB statement

USE [SQL2K8R2DB]

GO

/****** Object: Table [dbo].[CASEEVENT] Script Date: 08/05/2011 15:48:04 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[CASEEVENT](

[CASEID] [int] NOT NULL,

[EVENTNO] [int] NOT...

The task that I want to accomplish is summarised below:

FOR ANY CYCLE

FIND RECORDS

WHERE EVENTNO = -11 AND 1425

WHERE EVENTDUEDATE ARE NOT THE SAME

SELECT TOP 1000 [CASEID]

,[EVENTNO]

,[CYCLE]

,[EVENTDATE]

,[EVENTDUEDATE]

...

Thanks Gail

Could you please, explain which is suited for which? Thanks.

Thanks guys.

Many thanks to you and Steve Jones for your response.

Regards.

Tx for your response. I gambled already by installing SP2 straightaway.

Best regards.

Could someone look at this for me, PLEASE.

Many thanks.

Sorry, no date column but there is a primary key column. Can u give me a suitable t-sql code to use in all possible scenario. Tx.

Thanks so much Madhan_Pers,

I went to Book Online to get further information about how to carry out the instructions that you gave me and I got this

"In Object Explorer,...

Thanks so much Madhan_Pers,

I went to Book Online to get further information about how to carry out the instructions that you gave me and I got this

"In Object Explorer,...

After running the query, the only response that I got is command(s) completed successfully.

Like I mentioned, the database doesn't seem to have any problem but they are marked as suspects...

After running the query, the only response that I got is command(s) completed successfully.

Like I mentioned, the database doesn't seem to have any problem but they are marked as suspects...

Hi Lowell,

Many thanks for your response. Its really helpful and you've been able to give me a detail clarification.

Once again, thanks.

Regards,

Sahoong.