Louis,

This is a view table for my crystal report. It has 8 joined tables. It is so hard for me to post data. I figured out that I can...

Thank you very much, Louis.

Here is the data table.

Query statement for the table.

SELECT DNR_DONTN_MST.DNR_DONTN_ID, DNR_DONTN_MST.ACTL_PROC_CD

FROM DNR_DONTN_MST INNER JOIN

...

Thank you all so much. I know this structure is not good. I am new in this field. It is designed by vendor. I just need to modify this view...

Thank you Luis. Out hospital will definitely remove patient's middle name since it cause confusion with engine. One patient may have two or more records because of middle names. We...

Luis,

Thank you for your quick reply. Basically, there is one tables (PT_NAM) in the database I need to modify.

Here are 2 tables

PT_RED table

Column, ...

Thanks for your kind reply.

I resoved the problem with this simple command switch /passive.

http://support.microsoft.com/kb/973993