I'll take the advice given to me previous post. And check whether the query behaves differently with the BETWEEN operator and <> oprator.

I will post my answer.

Thanks for everybody.

I know,

If we look on my sp it's look like this: (example to insert user I run this sp)

USE [SynopSYS]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [Synopsys].[usp_InsertUser]

(

@UserName NVARCHAR(50)

)

AS

DECLARE @TransactionName NVARCHAR (50)

DECLARE...

In worst case 4 for diffrent tables.

Usually 1.

Hi Nevyn,

About the format that you treat, it is my mistake, should be 20100922112223.

Thanks

Hi Henry ,

When I insert any value to database I wrap the query with "begin transaction".

In my program I used with Entity Frame Work to deal with data.

In database there...

Hi Steve,

The column of date time defined as big int.

I tried to run your query and get with 2 min delay. It's better from 2 hours.

I need to test this...

The query is fine as well as values.

In fact, the DateTime is converted to a numeric value. Unfortunately, I have to use it until the next version.

Do you think if...

The view code is: (If you mean to my test)

SELECT Max (StartTime)

FROM [SynopSYS].[Report].[View_Report_Device_Events]

where starttime = 20100729192251

If you mean about in my program is:

SELECT

...

Ok, I ran some queries.

First, I ran the same query on the view and the table separately.

SELECT MAX (starttime) FROM MyView - get result 20100729182514

SELECT MAX (starttime) FROM MyTable...

Yes,

I think is a problem of index, Probably is not enough make the indexing process?

Forgive my rudeness, I thank you for your help and time investment :-).

Yes, I get same result.

About Date Time it is legacy issue and world time zone problem.

Yes, of course, it is very simple query.

The parsing of the condition date time is:

YYYY MM DD mm dd ss

2010 07 29 18 22 33

SELECT [Projects]

...

I am always running the same sql query command with diffrent Stamp Time, and I always get a missing data, such as - All data entered last two hours, I...

Unfortunately yes, before created an index on the view.

Yes, you're right. my mistake.:Whistling:

Does it solve my problem?

Can I see all the rows entering and not two-hour delay?

Anyway, I'll try it at the same time and write an...