No we don't modify PK values.

Jagan

EXTRACT_DATE is part of PK.

I got this set to Maximum Job History Rows per Job increased in SQL Server Agent Properties.

jagan

Thanks for the help.

Jagan

Can we use IF or CASE Statements in the Formula?

Jagan

I dropped and recreated the Test_VW but now it's showing up the following error:

Server: Msg 4416, Level 16, State 5, Line 1

UNION ALL view 'Test_VW' is not updatable because the...

I dropped and recreated the Test_VW but now it's showing up the following error:

Server: Msg 4416, Level 16, State 5, Line 1

UNION ALL view 'Test_VW' is not updatable because the...