Sorry,

I got that (previous ) wrong.

Done!

I used the following:

UPDATE STATISTICS table_name

Cant I just use the following:

UPDATE STATISTICS tabA.ColB;

GO

What I need is to update statistics on just one column. That column is used by an index.

USE dbx;

GO

UPDATE STATISTICS tabA.ColB;

GO

😛

Cool!

You thought I didn't GOOGLE ha ?

Take a look at the attached! LOL

OnPostExecute works well....

This is the best answer.

Found the issue!

Thanks for all the help.

SQL server throws an error message that is not realistic.

Team: Lets close this for now.. Later I will send you a detailed explanation on...

Luis:

I fully agree with your syntax but it still gives the same error.

May be some tweaking might help.

I think this might work...

I am not quite good at the SYNTAX.. can you help me out

UPDATE [VISIT_IN]

SET

[CLAIM_ID] =...

Luis and SQLBilly

Here is the fields that make the primary key

MEM_NBR, SERV_DT, CLAIM_ID, CLAIM_LINE_NBR in the VISIT_IN table.

Note:

clustered, ignore duplicate keys, unique, primary key located on PRIMARY

Luis:

The stored proc does not have one insert statement. That is why I was surprised.

The message comes as a result of the "UPDATE statement that I posted. I was surprised...

SQLBill:

I did not set the table to take in duplicates. When you run the following,

your table will no accept duplicates. But at the same time it will not throw errors...

Would you mind passing the SQL syntax please ? I am rather new to the SQL world.. Pardon my ignorance

Question for Luis

So what does this segment of code do ?

Can you send me a simple SqL statement on how to retrieve what you just added ?

I mean I am...

Yep ! I am in the HEALTHCARE business and have been told by another organization to include the changes.