Thanks a lot.... Mark and kramaswamy........:-)

Tried but again giving the same error -

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "The Microsoft Jet database engine could not find the object 'Testing$'. ...

It means what i am getting dirty or uncommitted records from second query (select top 10 * from Table1 With(NOLOCK).

Actually i am confused because of order by clause. When i...

I am using VB.Net as frontend and SqlServer2005 as RDBMS.

It is client's requirement that s/he wants to see all the records before and after updating.

As Michale and chirag suggest either...

Hi,

I faced the similiar situation like yours and find a solution in a blog -

Here is the query which is using INFORMATION_SCHEMA views that returns both sides of all...

Eventhough it si not at all a good idea but you can use cursor if no other option left.

Please specify the exact requirement as Lynn said. so that we can...

Hop this link can be helpful for you -

http://msdn.microsoft.com/en-us/library/cc295829.aspx

can u give an example or exact scenario. it will help us to solve your problem in a better way.

Hi,

Please specify clearly what you want to do?

But you can do the following things -

Create indexes for tables and views.

You can do all your insert/update/delete/Select using SP.

When you fetch...

Yes you right EDVassie - i am creating SP but i have to use cursor to update these records. As I have to create the log file for each and...

simplest way you can use is like this -

Example -

Create Table #Test(dt datetime , tm int)

Insert into #Test values(getDate(),1)

Insert into #Test values(getDate(),2)

Insert into #Test values(getDate(),3)

Insert into #Test values(getDate(),4)

Insert...

Thanks for the suggestion.

I worked on this approach and it works fine for me.

It improves update time by 40%.

Thanks again.

I am giving you the exact scenario -

1. I have a tab control with 3 tabs on it.

2. 1'st tab has a user interface for record filtering.

3. 2'nd tab...

Actually I am working on a Retail management ERP.

User filter records using different search criteria’s and wants to updates these records.

This is the worst scenario that s/he might select all...