Thanks Ten centuries:)

this is exactly what I need.

Sami

Try to find the inderlayer table that usually have these column name and check if they haven't been altered, renamed or simply removed.

As for why it just happened, he might...

Hello,

thanks for you reply.

After posting my question, I found the system built in stored procedure I needed to do what I want.

Like you suggested, I tried calling the SP sp_update_jobschedule....

Hi,

how about converting your PaycodeA to Char and then concatenate it with PaycodeB, it will give you One Natural Key. This way, you save one column.

How about it?

Sami