Hi my frnd, finally i was able to find a solution for the query time out issue. i used a temp table and then i called 3 updates to update 3 fields i required. and put everything in a stored procedure.. now its working fine. Thanks a lot my dear for encouraging me and providing me the required tips.....

Hi.. u can use any method including stored procedures, temp tables etc to accomplish the above scenario.. u have absolute freedom to choose your method.. thanks a lot..

Hi.. let me explain my requirement.. i need to display firstname, lastname, emailaddress from tblmembers, si.rows as 'Row_Count', optouts, count(addressbook) as 'invalid', row_count-(optouts+count(addressbook)) as 'valid' from tblusercategory (select m.firstname,m.lastname,m.emailaddress...

Hi, am back.. i think the entire problem can be solved if the deprecated join is fixed.. And the schema is given below: tblusercategory : ID (int), addressbook(int)(pk), categoryID (int)(pk), userID(int) (pk) tblcategorylist : ID (int), addressbook(int), categoryName(nvarchar), dataEntered(smalldatetime...

Hi dear friend, when i incorporated the query given by you as shown below, am getting errors.. select d.firstname,d.lastname,d.emailaddress,d.phone,d.Row_Count,d.optouts, count(a.addressbook) as 'invalid',d.row_count-(d.optouts+count(a.addressbook)) as 'valid' from tblusercategory a,...

Thanks dear.. How can i check whether the sysobjects table already has this WITH (NOLOCK) hint or not? Could u please guide me how to give WITH (NOLOCK) hint on the sysobjects table? To be frank.. this is the first time am hearing this!! sorry to disturb u again..

Thanks dear.. that error is gone.. If this does table scan, then a lot of time will be taken as i have thousands of tables.. right? Could u please tell me onething.. which choice will be faster.. 1)using sysobjects and sysindexes or 2)using sys.objects and sys.indexes and sys.partitions ( this has some...

addressbook is an int and the table contains some nvarchar type fields also.. i have just posted the actual scenario. Could you please have a look into it. This will make things easy i think.. Thanks Ratheesh

Thanks my dear friend.. please have a look into this case.. My requirement is: I have a table named tblmembers. some of the fields are addressbook, emailaddress, firstname, hasaddressbook.. select addressbook from tblmembers where hasaddressbook=1 the above query returns more than 4000 records. And I...

Dear friend, am getting error message like Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the nvarchar value 'tbl_taboo_imports' to data type int. tbl_taboo_imports is a table in the database. but it has nothing to do with the above code. Then I removed so.type_desc = 'user_table'...