Hi Lowell,
I'm using views to auto-decrypt the select statements. Can you please give me an example as to how I can use procs for insert/update/delete statements. I made some...

Hi Lowell,
I appreciate your prompt response. I do have all the encryption columns and data types set up with Symmetric and Asymmetic keys required for encryption. Here is the...

Any other recommendations?

Steve,
The idea behind creating a view is to allow programmers to perform CRUD operations using views. My table has firstname, lastname and e_firstname, e_lastname columns (encrypted columns using orginal...

I do not have any applications or non-DBA users that have sysadmin or DBO privs. How can we perform CRUD operations on the encrypted table? Once I get the view...

Jeff,
Can you suggest an alternative to views? Need help with this.

Thanks

Thank you very much

anthony- I tried using Luis's code and got below error message. Any inputs on what I may be doing wrong. Thanks.

Msg 208, Level 16, State 1, Line 19

Invalid object name...

All-I appreciate your response. In the salescode column there is single salescode also. How do I handle it? Here is the updated DDL. Is there a way to create 2...

Thank you again Luis

Luis,

The query you suggested works fine. I've a small issue with it. If there is Jobnumber that has OperationCode 2001 it still shows up. In the below DDL there is...

Thank you very much Luis.

Any help is appreciated. Thanks again everyone.

ScottPletcher,

Thank you for your help before. I've to create a new report where I have to show all the jobs that DO NOT have OperationCode 2001 and 2002. Any help...

ScottPletcher & Lowell- Thank you very much for your help.