thanks a lot Milzs.

is it system supplied SP? can you send the SP?

regards

I have involved in developing a system which is lot of concurrent users and for report generation purpose i want to fetch row without lock, then the records available for...

You are looking for a intersection of two tables, Exist() oparator to find this

Select * From T1 Where CustNo Exist(Select CustNo From T2 Where CustNo=T1.CustNo) and OrderNo Exist(Select OrderNo From T2 Where...

I know that it can be implemented using two different relations and integrated by foreign key relationship.

The SQL3 standard says it can be created as single entity. I want to...

You have to run as follow

DBCC CheckTable('Tablename')

Try & let me know.

regards

Shifan

You can write this query as following

select Person_id from P_Person where Comp_id>=1 and Comp_id<=2

or

select Person_id from P_Person where (Comp_id=1 or Comp_id=2)