nitin.iec (9/14/2009)

---

but suppose the Exceptional case when both insert and select(used in differnt systems and both usres using the same database) statement occured at the same time??then in this case...

marc.pollacchi (9/2/2009)

---

SELECT HD.ID,

HD.Force,

HD.[Column A] A,

HD.[Column B] B,

PC.[Column C] C,

HD.D

FROM dbo.[Table A]HD

left outer join (select HomID,[Last Name(s)]

from dbo.[Table B]

where [Person...

Thanks for your reply

I was able to solve the way Edogg suggested.

This is really crazy.... 🙂

Hi,

I assume Primary Key index is a clustered index.

Clustered index the data rows sorted themselves. Table storage and clustered primary key index cannot be in different file group, considering its...

if your formula is always the same, I suggest it is not the proper way of table design.

You will have to put the three attributes into three different fields...

Change the data type of the field registrationno from varchar to integer if it requires only numeric value.

Because creating index on integer field will be much faster than varchar fields...

Hi,

Thanks for your solution.

I have already downloaded the sqlbolsetup.msi from the same url.

But when I run that file, it gives me an error message,

"Installation package could not be opened

Contact the...