Hi,

You should used the between operator used to compare date.

Declare @Date varchar(30),

SET @Date = '20061024'

you can used any date which fulfill your requirement.

WHERE FieldName Between @Date + '05:05AM' AND...

Hi,

have a look on the artical

http://www.sqlservercentral.com/columnists/gvijayakumar/executionplans.asp

This will clarify you how SQL Server used cluster/non cluster Index.

Hope this will slove you problem.

Thanks

Hi,

When ever you modify or insert the data in the tables, SQL Server  generate the two table ' INSERTED' , 'DELETED'...

you can get any field values from these tables you...

Hi,

You just need to apply the where class and hopefully it will work fine.

Syntax look like this.

DELETE FROM CustomPropertyIRemoteProcVersion

WHERE